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 |
|
sql_2007
Starting Member
1 Post |
 Posted - 2007-09-04 : 13:22:19
|
| I just start my job as sql server DBA. We have disaster recovery plan. We implement Log shipping . My question after the server failiure, when production server up again ,how to point stand by server to production server?, any help will be appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-09-04 : 13:26:13
|
| Log shipping is very manual when a disaster occurs. You have to go to the secondary server and restore the logs manually. After the primary server is backup, you have to completely resetup log shipping again.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
how to point stand by server to prod server