Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 How to determine backup duration

Author  Topic 

matty1stop
Starting Member

37 Posts

Posted - 2006-12-15 : 11:18:41
This feels like a stupid question, but is there a way to determine the runtime of a database backup in SQL Server 2005? I am looking at the SQL Server logs and I see a record that states the backup was started but can't tell how long it takes.

Thanks for the help.

Matt

JoeNak
Constraint Violating Yak Guru

292 Posts

Posted - 2006-12-15 : 12:01:27
Go to the backup job, right click job history will do it in 2000. It's very similar for SQL Management Studio, I think it's just called "View History".
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2006-12-16 : 04:42:40
The timestamp of the file is the "end time" of the backup - if that helps at all
Go to Top of Page
   

- Advertisement -