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 |
|
jbarrier
Starting Member
4 Posts |
 Posted - 2009-02-09 : 11:52:26
|
| I have setup log shipping and now need to test our failover process. To conduct this test we will basically disconnect the primary from the network and step through our failover process. After completion of the failover test I plan to backup the databases from the secondary server, restore these databases on the primary and re-point applications to the original primary. My question is: does log shipping have to be setup from scratch again or can the jobs simply be disabled prior to the failover test and re-enabled after restoration of the original primary?Thanks!! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-09 : 15:02:20
|
| What happened when you tried? Did you disable backup,copy,restore jobs in Primary and secondary server after role change? Did you point new primary in Database Settings while reconfiguring? |
 |
|
|
jbarrier
Starting Member
4 Posts |
Posted - 2009-02-09 : 15:27:48
|
quote:
Originally posted by sodeep
What happened when you tried? Did you disable backup,copy,restore jobs in Primary and secondary server after role change? Did you point new primary in Database Settings while reconfiguring?
sodeep, I haven't tried at all yet, just trying to determine what my failback downtime will be.Tara, just to be clear. After failover testing if I do a full backup/restore and a transaction log backup/restore between the secondary and primary before bringing the original primary back on line both databases will be at the same LSN and the pre-testing SQL Server log shipping jobs will work? |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
jbarrier
Starting Member
4 Posts |
Posted - 2009-02-09 : 16:05:32
|
| Thanks so much!Jeff |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Log Shipping Disaster Recovery Test
Tara Kizer