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?
nmederich
0

Comments

3 comments

  • petey
    What version of SQL Backup are you using?
    petey
    0
  • nmederich
    The version I am using is 3.2.0.1

    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.
    nmederich
    0
  • petey
    I would suggest requesting for the latest patched version from Red Gate support.
    petey
    0

Add comment

Please sign in to leave a comment.