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

Moving SQL Backup Data.sdf

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
AMSUser
0

Comments

1 comment

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

Add comment

Please sign in to leave a comment.