Monitoring SQL Server Backups With DMV

I have a rather long-running backup that was started via Maintenance plan. So I have no output about the progress of a particular backup. In this case you can query DMV to get the information needed.

The output would be like this.


As you see, one backup is running while the others are pending.

Leave a Reply

Your email address will not be published. Required fields are marked *