Hi all, I have a rather perplexing issue regarding a scheduled T/log backup not executing!!
I'm using an agent job to automate the backup of one of our company DB's with T/log backups scheduled during the working week at 11:00, 15:00 & 18:00. Historically, the backup's have performed perfectly but yesterday the scheduled 18:00 T/log backup did not run according to the log (SQL Server 2008 R2).
As it didn't register on the log as a failure I wasn't notified by email and I can't for the life of me figure out why it wouldn't have run. I checked the actual schedule on the job it's perfectly fine, all historically scheduled 18:00 T/log backups executed and the full backup that was scheduled for 20:30 the same evening also executed perfectly.....does anyone have any ideas/suggestions what could have caused the problem?
Thanks for any help/suggestions in advance.
MCTS - E-Business Card
Try not! Do or do not, there is no try
Personal Website: www.markallen-online.co.uk
Business Website: www.weekendwebdesign.co.uk