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.
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'
ReplyDeleteIt is very good blog and useful for students
Sql server DBA Online Course Bangalore