--Display current backup/restore progress using DMVs.

--SQL 2005 and above

--From http://www.mssqltips.com/tip.asp?tip=2343

USE master

SELECT session_id AS SPID ,

CONVERT(VARCHAR(50), start_time, 100) AS start_time ,

percent_complete ,

CONVERT(VARCHAR(50), DATEADD(SECOND, estimated_completion_time / 1000,

GETDATE()), 100) AS estimated_completion_time ,

command ,

a.text AS Query

FROM sys.dm_exec_requests r

CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) a

WHERE r.command LIKE 'BACKUP%'

OR r.command LIKE 'RESTORE%'