Help Cleaning up Large Reg Gate Files

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Help Cleaning up Large Reg Gate Files

Postby qsac226 » Wed Mar 21, 2012 1:36 pm

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
qsac226
 
Posts: 11
Joined: Tue Feb 06, 2007 8:31 pm

Postby petey » Thu Mar 22, 2012 10:26 am

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
petey
 
Posts: 2233
Joined: Sun Apr 24, 2005 12:34 pm


Return to SQL Backup 6

Who is online

Users browsing this forum: No registered users and 0 guests