temp files taking up lots of space

[vincentj]

Hi,

My IT department told me that we were getting disk space warnings on our continuous integration server. Upon investigation, I found that there were 28 GB of temp files in C:\Users\build\AppData\Local\Temp\Red Gate.

Is this a bug, or is there a setting I can change to get SQL Compare/Data Compare to clean up these temp files?

[Brian Donahue]

I'm sorry that you are having this problem. SQL Compare/Data Compare has been known to leave some temp files but on this scale I'd check first that the commands aren't aborting or failing before the temporary files can be disposed. That could potentially leave entire tables of data behind in the temp folder.

In the meantime, Windows Disk Cleanup is the best tool to put the disk right.

I believe in order to get that on Windows 2008, you have to add the "Desktop experience" feature.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521

[Brian Donahue]

If you are using the "continuous integration" stuff from Red Gate (sqlci.exe/SQLCompare.exe with the /include:StaticData switch), this should be better in the next version. It's currently analyzing data for tables whose static data isn't linked.
_________________
Brian Donahue
Technical Support
Red Gate Software Ltd.
44 (0)870 160 0037 ext 8521
US and CAN 1-866-RED GATE ext 8521