Categories
Sql Server

SQL Server – When Will My Backup Finish?

SQL Server – When Will My Backup Finish?

In this post we will learn When Will My Backup Finish? in SQL Server.The sys.dm_exec_requests is a great way to find out how long the BACKUP will take to complete. If you are doing a backup WITH STATS or by GUI, you will not need to use the DMV. But, if someone else is running a backup (or a Job), you can find the percent of backup completed and estimated completion time using this DMV.

When a backup is running, you can use the below query to check the progress.

TSQL:

SELECT      COMMAND,PERCENT_COMPLETE,'ELAPSED TIME' = TOTAL_ELAPSED_TIME / 60000.0,
            'REMMAINING TIME' = ESTIMATED_COMPLETION_TIME / 60000.0
FROM        SYS.DM_EXEC_REQUESTS
WHERE       COMMAND LIKE 'BACKUP%'