How can we help you today? How can we help you today?

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
toad2898
0

Comments

3 comments

Sort by
  • 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.
    petey
    0
  • 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.
    toad2898
    0
  • petey
    Backup speed in MB/sec.
    petey
    0

Add comment

Please sign in to leave a comment.