How to find out SQL Server job and rollback complete percentage?

• YTZ

  SSCommitted

  Points: 1707

  More actions

  October 14, 2010 at 7:52 am

  #143179

  All:

  I want to check the complete percentage for long running job like backup/restore, and rollback.

  Any suggestion will be aprreciated

  Thanks

• ayonavo.sur-1045442

  SSC Rookie

  Points: 45

  More actions

  March 23, 2011 at 6:20 am

  #1302413

  You can check the completion percentages of any process through the DMV - sys.dm_exec_requests.

  Moreover, for Backup/Restore progress, that data can be watched through SSMS.

  Hope this helped!

• SkyBVI

  SSCoach

  Points: 15115

  More actions

  March 23, 2011 at 7:20 am

  #1302440

  track progress of backup--

  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%'

  order by percent_complete desc,B.TOTAL_ELAPSED_TIME/60000 desc

  Regards,

  Sushant

  Regards
  Sushant Kumar
  MCTS,MCP