| Author |
Message |
toad2898
Joined: 14 Sep 2009
Posts: 21
|
 Posted: Wed Feb 01, 2012 4:28 pm Post subject: backuphistory table |
 |
|
Are all backup attempts logged in here, whether they are sucessful or not?
I want to use this table for some stats but I only want to report on sucessful backups
Thanks |
|
| Back to top |
|
 |
petey
Joined: 24 Apr 2005
Posts: 2215
|
| Posted: Tue Feb 07, 2012 8:30 am Post subject: |
|
|
Yes, all backup attempts are logged here.
If you only want to report on successful backups, filter on the backup_set_uuid column. A non-empty value indicates a successful backup, and is a reference to the SQL Server backup_set_uuid column in the msdb..backupset table.
_________________
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7 |
|
| Back to top |
|
|
toad2898
Joined: 14 Sep 2009
Posts: 21
|
| Posted: Fri Feb 10, 2012 11:40 am Post subject: |
|
|
thanks.
Could you tell me what the speed column is? I'm curious as of the things I'm looking at is backup throughput times. |
|
| Back to top |
|
|
petey
Joined: 24 Apr 2005
Posts: 2215
|
| Posted: Fri Feb 10, 2012 11:59 am Post subject: |
|
|
Backup speed in MB/sec.
_________________
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7 |
|
| Back to top |
|
|
|
|
All times are GMT + 1 Hour
|
| Page 1 of 1 |
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
Powered by phpBB © 2001, 2005 phpBB Group
