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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-06-07 : 12:08:55
|
| Jose writes "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." |
|
|
jharwood
Starting Member
41 Posts |
Posted - 2004-06-07 : 12:13:02
|
| In Bol, look up sp_change_users_login. Also search on sqlteam for transferring logins.-J |
 |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-06-07 : 12:15:26
|
| search for sp_help_revlogin on the forum search. You'll find what you need from that.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Restoring data base