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 |
|
Peter99
Constraint Violating Yak Guru
498 Posts |
 Posted - 2011-04-01 : 11:36:47
|
| Hi,We are preparing for disaster recovery scenario. We have sql server 2005 cluster active/passive. After disaster we will rebuild two standalone servers of sql server 2005 and will restore msdb and users databases from netbackup. Cannot restore master as computer name will change. What I know that mostly logins are importat to move in new master database. I want to know is there any way I should script these logins on regular basis and when there is disaster, I will be able to restore these logins on new server? I need windows and sql server logins and their password, membership in each server and database roles etc.Thanks |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-04-01 : 13:09:10
|
| Thanks Tara for your help. As we are working on production server, I just want to make sure it is tested. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Peter99
Constraint Violating Yak Guru
498 Posts |
Posted - 2011-04-01 : 17:19:41
|
| Thanks Tara. Have a good weekend. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
moving logins