How can we help you today? How can we help you today?

Clear cached data

I'm running all my development environments (SQL, SSMS, VisualStudio, etc) within a VMware instance... which is backed up at least twice a week.  The size of the instance is ever increasing and I'm trying to find ways to reduce the size.

The following directory on my machine is currently sitting with over 3.5Gb of data (I only have SQL Source Control from Red Gate installed)...
C:\Users\{username}\AppData\Local\Red Gate\

Can you please tell me what directories I can safely remove, keeping all my linked databases in place?

Is there any possibility that you could add something (say, through the options) that would safely remove those file for us, with all appropriate warnings?
stonefish
0

Comments

5 comments

Sort by
  • Tianjiao_Li
    @stonefish

    The linked databases are stored in 
    LinkedDatabases.xml
    in C:\Users\{username}\AppData\Local\Red Gate\SQL Source Control 6. 

    You can delete the log folder which can take up lots of space if you have debug logging turned on. Unless for debugging, I'd suggest you to set the log level to Serious or turn off completely. Please see instructions for setting the log level here: https://documentation.red-gate.com/soc6/troubleshooting/logging-and-log-files

    Tianjiao_Li
    0
  • stonefish
    Thanks for your response... that's cleared 1.8Gb.

    Are there any other directories I can clear, such as any in the following directory...
    C:\Users\Tom\AppData\Local\Red Gate\SQL Source Control 6

    I'm thinking in particular things like Caches, Generic Transients, WorkingBases?


    stonefish
    0
  • Tianjiao_Li
    Indeed you can clear Caches without any issues.

    Generic Transients, WorkingBases are used to store snapshots of script folders. If you clean-up those folders, at the very least if things stop working you can do a re-link to your databases and everything should work again.
    Tianjiao_Li
    0
  • Tianjiao_Li
    @stonefish

    Just want to add that you can setup SOC so that it doesn't use caching. To do this, please edit
     %localappdata%\Red Gate\SQL Source Control 7\RedGate_SQLSourceControl_Engine_EngineOptions.xml

    and add the following:

    <EngineOptions version="3" type="EngineOptions">
<DisableCaching>True</DisableCaching>&nbsp;
</EngineOptions>

    You can also change the location of the Working Bases and Transient folder to other drive as well.https://documentation.red-gate.com/soc7/configuring/move-the-working-base
    Tianjiao_Li
    0
  • stonefish
    Many thanks once again for your replies.

    Clearing the Logs, Caches and Generic folders cleared well over 3Gb of storage
    stonefish
    0

Add comment

Please sign in to leave a comment.