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.
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". |
|
|
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 |
|
|
|
|
|