How can we help you today? How can we help you today?

SQL Backup Database Tables

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.
dbenoit
0

Comments

2 comments

Sort by
  • 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.
    petey
    0
  • 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.
    dbenoit
    0

Add comment

Please sign in to leave a comment.