What are the challenges you face when working across database platforms? Take the survey
Options

Help Cleaning up Large Reg Gate Files

qsac226qsac226 Posts: 22
edited March 22, 2012 5:26AM in SQL Backup Previous Versions
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

Comments

  • Options
    peteypetey Posts: 2,358 New member
    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 8
Sign In or Register to comment.