April 3, 2007 at 7:38 am
hey all,
A current application we had, had an issue. I had to backup the current db and then restore it to a separate server for archive. I only restored the database in question, but for running reports on the archived, I forget what database I need to restore in order to have all users show up. Please let me know. Thanks.
April 3, 2007 at 7:51 am
It would be the master, but that could cause you issues.
You only need to fix this once, so I'd do this one of two ways. You can run sp_Change_users_login to fix and add new logins. You can look this up in BOL.
The other thing to do if that doesn't work is to search for sp_help_revlogin on the MS site and get that script. You can use it to script out logins from the main server and add them to the new server. You still probably need sp_change_users_login to synch them up once they're added.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply