C:\\Documents and Settings\\All Users\\Application Data\\Red Gate\\SQL Backup\\Data\\(local)\\data.sdf
This is the database SQL Backup uses to store details of the backup and restore processes. You can manage its size by telling SQL Backup how much historical entries to store, using the 'Delete old backup history' option in the SQL Backup GUI 'Options' page of the server instance.
You can also relocate this file, though it must be done manually. To do so:
- ensure no scheduled SQL Backup backups or restores are running, or will run in the next few minutes
- ensure no SQL Backup GUIs are connected to your SQL Server instance, as this will start the SQL Backup Agent service
- stop the SQL Backup Agent service
- in the registry, look for the key 'DataPath' in the node - HKEY_LOCAL_MACHINE\\Software\\Red Gate\\SQL Backup\\BackupSettingsGlobal\\<instance name>
- the value should be the existing directory where data.sdf is located
- change the value to the new directory
- move the file to the new directory
- ensure that the SQL Backup Agent service startup account has read/write rights to the new directory
- start the SQL Backup Agent service
- check if a new data.sdf is created in the original directory, though this shouldn't happen.