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 |
|
jos.augrf
Starting Member
3 Posts |
 Posted - 2004-06-02 : 09:08:00
|
Hi, i have the following problem:I have two machines, one is a production machine and the other is a test machine. I made a bakcup of a database from the production and i want to restore it in the test enviroment. The bases are identically, but i know i'll face problems after restoration operation because the users in the test enviroment would lose their identification(They belong a diferent master database). My problem is how to become the database usefull for the same users present before the restoration process.Note: the names and the quantity of users are equal.Thanks in advance,Jose Augusto. |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-02 : 09:48:38
|
| Search for sp_help_revlogin on this site. You can use that script to migrate all the users from one server to another. You will need to run the script in the master database on your production database. It will give you a script with all the users, including the SID so the users match up. You will run that permissions script on the test server and all of your logins for the restored database will work.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
Restoring database