Comments
Sort by recent activity
Thanks for your comment, Brian.
I just to clarify that SQL Agent is not stopped, but hung. The session that comes from SQL Backup block every other processes in msdb and prevent the reports to be created. No deadlocks were detecetd during this situation.
To remediate, we simply kill the spid and everything goes back to normal.
Thank you.
Javier. / comments
Thanks for your comment, Brian.
I just to clarify that SQL Agent is not stopped, but hung. The session that comes from SQL Backup block every other processes in msdb and prevent the reports to be c...