Edward Dortland (8/23/2012)
what does this say:SELECTdb.name,
er.percent_complete,
er.total_elapsed_time/60000 AS ElapsedMinutes,
er.estimated_completion_time/60000 AS remaining_minutes
FROM
sys.sysdatabases db
INNER JOIN sys.dm_exec_requests er
ON db.DBID=er.database_id
AND er.command LIKE '%BACKUP%'
and does the output change over time?
Edward
I get nothing.. since it is not running at this time of day.
The output doesnt really change as far as the size of the backups.
Michael B
Data Architect
MCT, MCITP(SQL DBA 2005/2008),MCTS, MCP,MCDBA