SQL Server Performance Forum – Threads Archive

Job Schedule stuck?

We have a SQL 2005 Server with an hourly tlog backup job scheduled. The server was taken down last night for maintenance and one of the hourly tlog backups was missed. When the server was brought back up the tlog job failed to run at the next hourly interval. According to the job, the next execution time still reflects the time the server was down? Has anyone else seen this behavior?

BEtter to perform a full database backup and then continue the Tlog backups. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided Ã¯Â¿Â½AS ISÃ¯Â¿Â½ with no rights for the sake of knowledge sharing.

A full backup was taken prior to the maintenance. To get the tlog backup job to begin executing I had to delete the job schedule and create a new one. Weird!

Is SP1 installed on SQL 2k5?
Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
http://www.SQL-Server-Performance.Com
This posting is provided Ã¯Â¿Â½AS ISÃ¯Â¿Â½ with no rights for the sake of knowledge sharing.

No, we have not installed SP1

]]>