how to query backup history in v4

irabufan

Hi,

I noticed that in redgate sql backup 5, you can write queries in T-SQL to get backup history information (ie. file backup size, compressed file size, etc.) by using the sqbdata extended stored procedure. I noticed that the GUI on sql backup 4 can also show a backup's compressed size and ratio, but since sql backup 4 doesn't have this sqbdata extended stored procedure, is there any way i can query this information via T-SQL with sql backup 4?

btw I'm mostly interested in the compressed backup size information so i can monitor the database backup's growth over time for capacity planning purposes

thanks

petey

In version 4, the information is encoded in the msdb..backupmediafamily table. See http://www.red-gate.com/messageboard/viewtopic.php?t=2241 on how the values are encoded.

In version 5, the same information is stored in the backupmediafamily table. In addition, SQL Backup stores the information in a local SQL Server Compact database. That is the data that is returned by the sqbdata extended stored procedure. It was done to allow us to record backup failures, and also to store information on restore processes.

irabufan

got it thanks!