Moving SQL Backup Data.sdf

Forum for users of Redgate's SQL Backup tool

Moving SQL Backup Data.sdf

Postby AMSUser » Tue Oct 09, 2012 8:46 pm

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

Posts: 1
Joined: Tue Oct 09, 2012 8:12 pm
Location: United States

Postby petey » Wed Oct 10, 2012 1:26 am

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
Posts: 2358
Joined: Sun Apr 24, 2005 11:34 am

Return to SQL Backup Previous Versions

Who is online

Users browsing this forum: No registered users and 0 guests