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

SQL Log Backup of MSDB is hung.

lacain57lacain57 Posts: 7
edited November 13, 2014 5:48PM in SQL Backup Previous Versions
I have noticed the log backup for the msdb backup had not executed in several days. I attempted to restart it by re-starting the SQL Server Agent
but it just creates another process, without completing.

There are several processes with the application SQBCoreService.exe with Task State is Suspended and Wait Type is LCK_M_U in the Processes section of the Activity Monitor.

How do I stop these processes gracefully without effecting the msdb database?

Any help will be appreciated.

Comments

  • Options
    I was able to resolve this myself.

    After doing some additional research I found some information that said when a Redgate job get hung was to stop and start the SQL Backup Agent.

    Once I had stop and started to agent, the jobs hung in the a Suspended state dropped and were removed the In Progress tab in the GUI.

    You would think that moderators of this forum would have been able to point me in this direction. I guess they really aren't there to assist anyone.
Sign In or Register to comment.