January 17, 2012 at 11:28 pm
what are the possibilities of log shipping breaks .....
My views are
1.if some 1 changed the recovery mode from full to simple
2.if sql agent service is stopped
3if there is network issue....
any other possibilities of this....please share
Regards,
Shivrudra W
January 18, 2012 at 12:51 am
Take another log backup outside of the schedule to a different location
Daylight savings changes can occasionally have an impact
January 18, 2012 at 1:21 am
* Secondary server's service account losing read access on the shared folder on primary containg log backups.
* Breaking of log chain.. ( Changing recovery model, taking backup to different location, Backup log to NUL ) etc.
Regards,
Raj
January 19, 2012 at 8:47 am
What if the disk on the secondary server got full and the backup files dont get copied. If this is not identified within reasonable time then the log backup files on the primary will start getting deleted if you have configured the log backup job on primary with less retention time. You will lose log backups in such a scenario.
Blog
http://saveadba.blogspot.com/
January 19, 2012 at 10:23 am
if log files got deleted.. then
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply