SQL Backup Database Tables

dbenoit

Greetings,

Is there a list available of the tables within the SQL Backup database. I know of some but I am wondering if there are others that will help in reporting for our environment.

Thanks in advance for any information you can provide.

petey

On the server where SQL Backup is installed, backup and restore operations ran by SQL Backup are stored in a SQL Server 2005 Compact database. The data file is named data.sdf, and is stored in this folder by default: C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Data\<instance name>.

You can use SSMS to open this database. You can also use the sqbdata extended stored procedure to run queries against this database e.g.

EXEC master..sqbdata 'SELECT * FROM backuphistory'

There are only 6 tables in this database, 3 for backups and 3 for restores. They are backuphistory, backuplog, backupfiles, restorehistory, restorelog and restorefiles.

dbenoit

Peter,

Thank you for the information. I did know about the extended stored procedure from another post so, I was using that. Just wondered what other information might be available to us from your db for capacity planning and reporting.

Thanks again.