n00bDBA (8/29/2012)
Hi,Yes had a brain melt..
realized that i still had my ola scripts still doing backup logs...
That's pretty much what i was expecting 😉
n00bDBA (8/29/2012)
What would happen if the WAN went down and a log file was skipped. Would log shipping still work? and it just skip that 1 hour of activity? or does it stop.
This depends on how long it was down for and the file retention period set on the primary.
If the WAN was down for 4 hours but the log backups are removed on the primary after 2 hours then yes, when the WAN came back the restore job would complain because the log backups its recently collected and trying to restore have a gap.
n00bDBA (8/29/2012)
If it stops. How do you get it unto date (Manual restore of log files?)If it just skips (which i wouldn't have thought it would) how do you put in the old log files.
Thanks for the reply.
If you get to this point and there are log backups missing due to the scenario mentioned above do the following;
Disable all LS jobs for this database (i.e. backup, copy and restore)
take a differential backup on the primary
restore the differential to the secondary
clear all log backups from the primary and secondary locations
Re enable LS jobs (backup, then copy, then restore)
If you get to this point and all the log backups are in place on the primary then just run the copy job followed by the restore job.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉