USE MASTER
SELECT
       SESSION_ID [spid] ,
        '[' + CAST( DATABASE_ID AS VARCHAR(10 )) + '] ' + DB_NAME (DATABASE_ID) AS [DB],
       PERCENT_COMPLETE [%] ,
       START_TIME [Started] , STATUS [Sts], COMMAND [Cmd] ,
        DATEADD(MS , ESTIMATED_COMPLETION_TIME, GETDATE()) AS [Est.Comp.Time] ,
       CPU_TIME [CPUTime]
FROM SYS .DM_EXEC_REQUESTS
WHERE
       COMMAND LIKE '%BACKUP%'
               OR COMMAND LIKE '%RESTORE%'
               OR COMMAND LIKE '%DBCC%'