n00bDBA (8/30/2012)
Hi Perry thanks!Can i just confirm im understanding it right.
CASE 1 - logs retained on Primary and secondary for 24 hours - 1 hour LINK down
10:00 - Log backup of Primary
10:01 - Copy log to Secondary
10:05 - restore log to Secondary
10:10 --- WAN LINK DIES...
10:30 - Log backup of Primary
11:00 - Log backup of Primary
11:10 --- WAN LINK RESTORED --
11:30 Log backup Primary
11:31 - copy of 10:30, 11:00 and 11:30 to Secondary
11:35 - Restore of 10:30, 11:00 and 11:30 to Secondary
CASE 2 - logs retained on Primary and secondary for 24 hours - Multi day LINK down
Fri 10:00 - Log backup of Primary
Fri 10:01 - Copy log to Secondary
Fri 10:05 - restore log to Secondary
Fri 10:10 --- WAN LINK DIES ---
Tue 9:00 ---- WAN LINK RESTORED ---
Tue 9:01 - Disable all Log Shipping Jobs
Tue 9:05 - Differential Backup of Primary
Tue 9:10 - Restore Differential backup to Secondary
Tue 9:15 - Move all Log files from Primary backup location and Secondary
Tue 9:20 - Enable all Log shipping Jobs
Tue 9:30 - Log backup of Primary
Tue 9:31 - Copy log to Secondary
Tue 9:35 - Restore log to Secondary
Tue 9:40 - Return log file to backup locations for Primary and Secondary
Thanks for the help!
Before looking at any of this wee need to know the thresholds you have set on the LS config for the database in question, can you supply these?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉