Moving SQL Backup Data.sdf

AMSUserAMSUser Posts: 2
edited October 9, 2012 9:26PM in SQL Backup Previous Versions
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
· Share on Twitter

Comments

  • peteypetey Posts: 2,358 New member
    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 8
    · Share on Twitter
Sign In or Register to comment.