Clay Lenhart wrote:
> There are scenerios within SQL Server that can block a backup. I'd
> look at the processes in SQL Server to see if there is any blocking.
That was indeed the case, one backup to virtual device process was hung.
I killed it and I can now backup the database.
So, this leads me to ask, can MSBP realize that it's not making progress
and terminate reporting error instead of waiting forever?
(A secondary question is why/when such a backup process stops
progressing, but that is probably dependent on my specific setup and load)
Thanks,
V.
|