backuphistory table

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

backuphistory table

Postby toad2898 » Wed Feb 01, 2012 4:28 pm

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
 
Posts: 29
Joined: Mon Sep 14, 2009 2:36 pm

Postby petey » Tue Feb 07, 2012 8:30 am

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
petey
 
Posts: 2233
Joined: Sun Apr 24, 2005 12:34 pm

Postby toad2898 » Fri Feb 10, 2012 11:40 am

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
 
Posts: 29
Joined: Mon Sep 14, 2009 2:36 pm

Postby petey » Fri Feb 10, 2012 11:59 am

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
petey
 
Posts: 2233
Joined: Sun Apr 24, 2005 12:34 pm


Return to SQL Backup 6

Who is online

Users browsing this forum: No registered users and 0 guests