Help Cleaning up Large Reg Gate Files

qsac226

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

petey

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.