Red Gate forums :: View topic - Help Cleaning up Large Reg Gate Files
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

Help Cleaning up Large Reg Gate Files

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



Joined: 06 Feb 2007
Posts: 11

PostPosted: Wed Mar 21, 2012 1:36 pm    Post subject: Help Cleaning up Large Reg Gate Files Reply with quote

Hello

I have two very large files, that appear to be some Red Gate files. Can you please advise on how I can clean these up? Are they needed? Maybe they need to be moved? What roles do they play in the application?

C:\Documents and Settings\admin\Local Settings\Application Data\Red Gate\SQL Backup\Server Data\1.dat

AND

C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Data\(local)\data.sdf

Thanks
Q
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2306

PostPosted: Thu Mar 22, 2012 10:26 am    Post subject: Reply with quote

Quote:
C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Data\(local)\data.sdf

This is the database SQL Backup uses to store details of the backup and restore processes. You can manage its size by telling SQL Backup how much historical entries to store, using the 'Delete old backup history' option in the SQL Backup GUI 'Options' page of the server instance.

You can also relocate this file, though it must be done manually. To do so:
- ensure no scheduled SQL Backup backups or restores are running, or will run in the next few minutes
- ensure no SQL Backup GUIs are connected to your SQL Server instance, as this will start the SQL Backup Agent service
- stop the SQL Backup Agent service
- in the registry, look for the key 'DataPath' in the node - HKEY_LOCAL_MACHINE\Software\Red Gate\SQL Backup\BackupSettingsGlobal\<instance name>
- the value should be the existing directory where data.sdf is located
- change the value to the new directory
- move the file to the new directory
- ensure that the SQL Backup Agent service startup account has read/write rights to the new directory
- start the SQL Backup Agent service
- check if a new data.sdf is created in the original directory, though this shouldn't happen.
_________________
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