Red Gate forums :: View topic - temp files taking up lots of space
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Compare 10
SQL Compare 10 forum

temp files taking up lots of space

Search in SQL Compare 10 forum
Post new topic   Reply to topic
Jump to:  
Author Message
vincentj



Joined: 17 Feb 2011
Posts: 36

PostPosted: Mon Jan 14, 2013 5:04 pm    Post subject: temp files taking up lots of space Reply with quote

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?
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6670

PostPosted: Tue Jan 15, 2013 12:02 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Brian Donahue



Joined: 23 Aug 2004
Posts: 6670

PostPosted: Thu Jan 17, 2013 12:22 pm    Post subject: Reply with quote

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.
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group