Log backup doesn't finish
nmederich
Posts: 3
I have SQL Agent schedule to do a log backup every 2 hours on a database. The Agent job calls the SQLBackup extended stored procedure of course.
Sporadically the Agent job will stay in "executing" status for days on end until I kill it manually. It is a small database with little to no activity. Typically the log backup will complete successfully in about 7 seconds. But then out of the blue it do this weird thing and not complete.
How do I fix this?
Sporadically the Agent job will stay in "executing" status for days on end until I kill it manually. It is a small database with little to no activity. Typically the log backup will complete successfully in about 7 seconds. But then out of the blue it do this weird thing and not complete.
How do I fix this?
Comments
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
It appears that the log is backed up successfully and all the work is done but the job just hangs open until I kill it. This doesn't happen on any other jobs on the server so it must be something with the SQL Backup extended stored proc or my implementation of it.
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8