What are the challenges you face when working across database platforms? Take the survey

Log backup doesn't finish

nmederichnmederich Posts: 3
edited December 18, 2005 1:38AM in SQL Backup Previous Versions
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?


Sign In or Register to comment.