Unanswered: SQL Server Transaction Log backup hanging
I created a db maintenance plan to backup 5 databases, (tranaction log backups) and it was working fine until a couple of days ago when I noticed that the job would still be running the next morning, and I have cancel it or reboot the server.
The job backed up 4 of the databases but just hangs while backing up the 5th. I can perform a transaction log backup via EM fine.
When I reboot the server it works fine for half a day and the same thing happens again.
There are no error messages in job history because I cancelled it. There
are no errors in the sql log. There are no errors in Windows event