temp files taking up lots of space

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

temp files taking up lots of space

Postby vincentj » Mon Jan 14, 2013 5:04 pm

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?
vincentj
 
Posts: 36
Joined: Thu Feb 17, 2011 10:20 pm

Postby Brian Donahue » Tue Jan 15, 2013 12:02 pm

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
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Postby Brian Donahue » Thu Jan 17, 2013 12:22 pm

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
 
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Compare 10

Who is online

Users browsing this forum: Calpertyk and 0 guests