Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
esthera
Master Smack Fu Yak Hacker
1410 Posts |
 Posted - 2007-03-01 : 03:56:25
|
| if i backup a db and restore it to a new db -- will this keep all identities and relationships that exist? |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-03-01 : 04:32:34
|
yes. The table, stored procedure, udf, & data will be intact.
KH |
 |
|
|
TonyTheDBA
Posting Yak Master
121 Posts |
Posted - 2007-03-05 : 09:35:33
|
BUT if you restore it to a new db on a different server, all teh Users will be in the database, but they won't have logins on the server . . . and when you try to create the logins they will have different SIDS so you need to first identify the users SID, then then use sp_addlogin @loginname = 'username' , @passwd = 'password' , @sid = 'users SID' the full syntax is in Books online. To get the users SID use sp_helpuser in your recently restored DB.Hope this helps and doesn't cloud the Issue-- RegardsTony The DBA |
|
|
|
|
|
|
backup and restore