how to check the database restore [with norecovery] progress

Question

how to check the database restore [with norecovery] progress in %

Answer 1

Hi @MRVS FLY ,

Have a look at Alberto's reply over this thread:
https://stackoverflow.com/questions/53613245/azure-point-in-time-restore-query-for-checking-progress

----------

If the reply was helpful please don't forget to upvote and/or accept as answer, thank you!

Best regards,
Leon

Answer 2

@MRVS FLY For SQL Server, you can get the progress by querying sys.dm_exec_requests.

SELECT session_id as SPID, command, a.text AS Query, start_time, percent_complete, dateadd(second,estimated_completion_time/1000, getdate()) as estimated_completion_time  
FROM sys.dm_exec_requests r CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) a  
WHERE r.command in ('BACKUP DATABASE','RESTORE DATABASE')  

More details are here

----------

If an answer is helpful, please "Accept answer" or "Up-Vote" which might help other community members reading this thread.