Red Gate forums :: View topic - backuphistory table
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 6
SQL Backup 6 forum

backuphistory table

Search in SQL Backup 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
toad2898



Joined: 14 Sep 2009
Posts: 25

PostPosted: Wed Feb 01, 2012 4:28 pm    Post subject: backuphistory table Reply with quote

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
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2277

PostPosted: Tue Feb 07, 2012 8:30 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
toad2898



Joined: 14 Sep 2009
Posts: 25

PostPosted: Fri Feb 10, 2012 11:40 am    Post subject: Reply with quote

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
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2277

PostPosted: Fri Feb 10, 2012 11:59 am    Post subject: Reply with quote

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
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic 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