August 13, 2014 at 5:40 am
Hi All,
Couple of quick questions on log shipping. Appreciate your help on this.
Question1) What is the use of monitor server in log shipping? It does not help in automatic failover as witness server does in Database mirroring?
Question2) In log shipping,if a log backup file is missing or corrupted then log shipping is broken and we cannot restore any further backups. My question is, is there any workaround for this problem without have to setup log shipping from scratch i.e fresh full bkp and log bkp n restore WITH NORECOVERY option?
Thank you.
August 13, 2014 at 6:04 am
The monitor server is used to monitor information about files copied over between the principle and secondary servers, failures, etc (http://msdn.microsoft.com/en-gb/library/ms187103.aspx)
If your missing a log, or the log is not re storable, then you have a broken log chain and the only way to correct that is to generate a full/differential backup depending on your backup strategy and start taking logs again on the principle, then restore it on the secondary with norecovery up to the latest possible point in time.
August 13, 2014 at 9:44 am
Thank you Anthony.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply