Skip to Content

We can use below select command to check backup/restoration percentage. 

We can execute this query when MS SQL Backup or restoration is in progress.

Also this query will show the processes which are running in DB (Backup, Restore, rebuild, compression)

===========================================

SELECT command,

s.text,

start_time,

percent_complete,

CAST(((DATEDIFF(s,start_time,GetDate()))/3600) as varchar) + ‘ hour(s), ‘

+ CAST((DATEDIFF(s,start_time,GetDate())%3600)/60 as varchar) + ‘min, ‘

+ CAST((DATEDIFF(s,start_time,GetDate())%60) as varchar) + ‘ sec’ as running_time,

CAST((estimated_completion_time/3600000) as varchar) + ‘ hour(s), ‘

+ CAST((estimated_completion_time %3600000)/60000 as varchar) + ‘min, ‘

+ CAST((estimated_completion_time %60000)/1000 as varchar) + ‘ sec’ as est_time_to_go,

dateadd(second,estimated_completion_time/1000, getdate()) as est_completion_time

FROM sys.dm_exec_requests r

CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) s

WHERE r.command in (‘RESTORE DATABASE’, ‘BACKUP DATABASE’, ‘RESTORE LOG’, ‘BACKUP LOG’)

===========================================


We can execute this query from SAP level.

Go to DB02 –> Performance –> Additional Functions –> SQL Command Editor.


This will show the output of any SQL query statements.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply