Status Restore / Backup

Backup status

use master
go
select 	percent_complete,
		(estimated_completion_time/1000)/60 as minutes,
		((estimated_completion_time/1000)/60)/60 as hours
from sys.dm_exec_requests where command like '%backup%'

Restore status

use master
go
select 	percent_complete,
		(estimated_completion_time/1000)/60 as minutes,
		((estimated_completion_time/1000)/60)/60 as hours
from sys.dm_exec_requests where command like '%restore%'

This site uses Akismet to reduce spam. Learn how your comment data is processed.