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 |
|
vaddi
Posting Yak Master
145 Posts |
 Posted - 2006-10-24 : 14:55:38
|
| Hello,I am trying to automate the process of restoring the test database from the production database.I have some users on the test database , for whom I should be giving back the logins and passwords.How can I do this . Is there any script or procedure I can follow.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-24 : 15:21:18
|
| http://www.sqlmag.com/articles/index.cfm?articleid=16090&Tara Kizer |
 |
|
|
Kristen
Test
22859 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2006-10-24 : 17:24:57
|
| You don't need to unorphan accounts if you use the method that I posted. It retains the sid.Tara Kizer |
|
|
|
vaddi
Posting Yak Master
145 Posts |
Posted - 2006-10-24 : 19:37:25
|
| Thanks for the scripts,The script seems to be great . But that was for when moving the databases from one server to another.What exactly I wanted is : I am restoring the database from a prodcution sql server 2000 to test sql server 2000. For example there are a,b,c,d,e logins on production database. And the test database has only logins a,b,c with different passwords.So what I am thinking is to take logins and passwords of the test database users before the restore and then after the database is restored ....then restore the user login and passwords as I have collected the information before.I am not sure if I am thinking the right way.Thanks |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-10-25 : 00:45:44
|
| "You don't need to unorphan accounts if you use the method that I posted."The thread I posted is called "Fix Orphaned Users" but includes links to other relevant material - including the one you posted, as it happens!Kristen |
|
|
|
|
|
|
Restoring user logins & permissions , DB restore