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