DBA- How To Find Out How Much Percentage Of Database Restoration Is Done?

Sometime we run SQL Server agent jobs to restore databases. As restoration is in progress, the below query can be used to find out how much percentage of restoration is completed.


SELECT command,
       percent_complete,
       start_time,
       Txt.[text] AS Query 
FROM   sys.dm_exec_requests AS DER
       CROSS APPLY sys.Dm_exec_sql_text(DER.[sql_handle]) AS Txt
WHERE  command = 'RESTORE DATABASE'



1 comment:

  1. I unequivocally got what you mean, a commitment of appreciation is all together for posting. Girls Services in Delhi Similarly, I am a dazzling store of really happy to find this site on the universe of Google

    ReplyDelete