Clear cached data

stonefish

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?

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

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.

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?

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

stonefish

Many thanks once again for your replies.

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