Skip to content

TO TRACK THE PERCENTAGE\PROGRESS OF BACKUP

[1] JOB COMPLETION STATUS
=========================
SELECT percent_complete, *
FROM sys.dm_exec_requests
WHERE session_id = <spid of the rollback process>
 
[2] BACKUP  JOB COMPLETION STATUS
==================================
SELECT A.NAME,B.TOTAL_ELAPSED_TIME/60000 AS [Running Time],
B.ESTIMATED_COMPLETION_TIME/60000 AS [Remaining],
B.PERCENT_COMPLETE as [%],(SELECT TEXT FROM sys.dm_exec_sql_text(B.SQL_HANDLE))AS COMMAND FROM
MASTER..SYSDATABASES A, sys.dm_exec_requests B
WHERE A.DBID=B.DATABASE_ID AND B.COMMAND LIKE ‘%BACKUP%’ —-> YOUR DB NAME HERE
order by percent_complete desc,B.TOTAL_ELAPSED_TIME/60000 desc
Advertisements
Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: