backuphistory table

toad2898

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

petey

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.

toad2898

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.

petey

Backup speed in MB/sec.