Red Gate forums :: View topic - Moving SQL Backup Data.sdf
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 6
SQL Backup 6 forum

Moving SQL Backup Data.sdf

Search in SQL Backup 6 forum
Post new topic   Reply to topic
Jump to:  
Author Message
AMSUser



Joined: 09 Oct 2012
Posts: 1
Location: United States

PostPosted: Tue Oct 09, 2012 9:46 pm    Post subject: Moving SQL Backup Data.sdf Reply with quote

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
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2277

PostPosted: Wed Oct 10, 2012 2:26 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message Send e-mail
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group