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 |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
 Posted - 2010-06-11 : 11:44:26
|
| hi everyone,I'm exploring various options to get logins and jobs created on my alternate/failover SQL Server. We have not kept it in-sync with the primary server. When we created new logins and jobs on the primary server, we did not always create those on the failover server at the same time.I know I can script these objects out ....** But if I stop SQL services on the primary and copy the master and msdb database files --> the failover SQL Server .... what will happen when I start MSSQL on the failover server? Does this trick have a snowball's chance in @#$% of working ?Thanks for opinions. John |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Copying System Databases to Another Server