Moving SQL Backup Data.sdf

[AMSUser]

Sorry if this is a repeat, I have been having issues searching the forums.

I am upgrading some storage, and found a data.sdf file on a drive that is marked to be removed. Is there a link as to how to move this? We are running version 6.4.0.56


Thanks,
Chris

[petey]

That file contains details of backup and restore operations performed by SQL Backup.

To move this file:

- close all SQL Backup GUIs connected to your SQL Server instance
- stop the SQL Backup Agent service
- look for HKEY_LOCAL_MACHINE\Software\Red Gate\SQL Backup\BackupSettingsGlobal\<instance name> in the registry
- change the 'DataPath' value to the folder where you want to move the data.sdf file to
- move the data.sdf file to that new folder
- restart the SQL Backup Agent service
- start the SQL Backup GUI, connect to that instance, and check if the backup/restore history details show up correctly
_________________
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7