The time required to complete the query is fairly accurate.
--Query The approximate completion time for operations such as backup or restore Selectcommand, Percent_complete, Running_time=Convert(varchar,((DateDiff(S,start_time,getdate()))/3600))+'Hour,' +Convert(varchar,((DateDiff(S,start_time,getdate()))%3600/ -))+'min,' +Convert(varchar,((DateDiff(S,start_time,getdate()))% -))+'sec', Est_time_to_go=Convert(varchar, (Estimated_completion_time/ +)/3600)+'Hour,' +Convert(varchar, (Estimated_completion_time/ +)%3600/ -)+'min,' +Convert(varchar, (Estimated_completion_time/ +)% -)+'sec', Start_time=Convert(Char( -), Start_time, -), Est_completion_time=Convert(Char( -),DateAdd(Second,estimated_completion_time/ +,getdate()), -), S.text fromsys.dm_exec_requests R Crossapply Sys.dm_exec_sql_text (r.sql_handle) swhereR.commandinch('BACKUP DATABASE','RESTORE DATABASE','BACKUP LOG','RESTORE LOG','dbccfilescompact','Dbccspacereclaim')
Approximate completion time for operations such as SQL query backup or restore