With regards to sqbdata
SQL Backup stores details of its processes in a SQL Server Compact database. Default location is 'C:\\Documents and Settings\\All Users\\Application Data\\Red Gate\\SQL Backup\\Data\\<instance name>' on Windows 2003 and older, and 'C:\\ProgramData\\Red Gate\\SQL Backup\\Data\\<instance name>' on Windows Vista and newer. You can open this database using SQL Server Management Studio (select the 'SQL Server Mobile' server type).
sqbdata is a SQL Backup extended stored procedure that allows you to run commands against the above SQL Server Compact database. You can run any valid SQL Server Compact command using it e.g.
- Code: Select all
EXEC master..sqbdata 'SELECT * FROM INFORMATION_SCHEMA.TABLES'
However, you should ignore the 'rows affected' values for DDL commands, as that will not reflect the actual no. of rows inserted/updated/deleted.
With regards to the backupfiles_copylist
This is a table in the above-mentioned database that stores details of the files that need to be copied to one or more directories. Possible 'status' column values are as follows:
A = active. SQL Backup is currently attempting to copy the file.
S = successful. SQL Backup has copied the file successfully.
P = pending. The file is waiting to be copied.
C = cancelled. The file will not be copied. This happens when the local source file no longer exists.
E = expired. SQL Backup has hit the limit for the maximum number of tries to copy the file and will no longer attempt to copy the file.