Archive for August 24, 2009

Backup Times

Posted: August 24, 2009 in Uncategorized


Earlier this summer I did a workshop on what I consider to be the most important thing that you can do with your database. That is back it up and restores. In my opinion this is job number one as a database administrator. Recently a friend of mine (Tom Roush) ran across a nifty little script that he uses to determine how long it will take for a backup to complete after it has started. Since it is a bit late to include in the workshop I figured that I would post the script here. Just to be clear, I am not the author of the script nor is Tom, but we found it really useful. If you are the author drop me a note so I can pass credit along.




    percent_complete AS

    start_time AS

    command AS
‘Command’, AS


    (estimated_completion_time/1000/60) AS

sys.dm_exec_requests a

sys.databases b

ON a.database_id = b.database_id

WHERE command like ‘%backup database%’

    AND estimated_completion_time > 0