February 3, 2009 at 2:08 am
I have log shipping configured in my system ,Some time i face problem that restore operation in secondary server continuously fail,It showed gap in the log chain.
Please anyone help me to solve this issue
February 6, 2009 at 3:14 pm
Manually restore the missing log, if you still have the log files..
Otherwise, you have to restore the full backup from the Primary DB. then restart the logshipping.
If the DB is not so big, the latter method is neater.
February 6, 2009 at 3:17 pm
look for evidence log backups or log truncations are happening outside of your logshipping set up. All backups are recorded in the errorlog to so look through that around the time log shipping first failed to load.
---------------------------------------------------------------------
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply