What are the challenges you face when working across database platforms? Take the survey

how to query backup history in v4

irabufanirabufan Posts: 3
edited July 10, 2007 5:18AM in SQL Backup Previous Versions

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



Sign In or Register to comment.