Tuesday, September 11, 2012

How to find the percentage completion of backup and restore operation

Run the below script and it will give the percentage of backup and restore operation.

Find the session id that is doing the backup or restore from sys.processess.

SELECT percent_complete , (estimated_completion_time/1000)/60 Estimated_completion_time_Mins ,
(total_elapsed_time/1000)/60 Total_Elapsed_Time_Mins ,DB_NAME(Database_id) DBName ,*FROM sys.dm_exec_requests WHERE session_id='id which is doing the operation'

1 comment: