USE MASTER
--
SELECT SESSION_ID, '[' + CAST(DATABASE_ID AS VARCHAR(10)) + '] ' + DB_NAME(DATABASE_ID) AS [DATABASE], 
PERCENT_COMPLETE, START_TIME, STATUS, COMMAND, 
DATEADD(MS, ESTIMATED_COMPLETION_TIME, GETDATE()) AS ESTIMATED_COMPLETION_TIME, CPU_TIME
FROM SYS.DM_EXEC_REQUESTS 
--Apply this Where Clause Filter if you need to check specific events such as Backups, Restores,
WHERE COMMAND LIKE '%BACKUP%' OR COMMAND LIKE '%RESTORE%'