Red Gate forums :: View topic - Out of Disk space
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Comparison SDK Previous Versions
SQL Comparison SDK Previous Versions forum

Out of Disk space

Search in SQL Comparison SDK Previous Versions forum
Post new topic   Reply to topic
Jump to:  
Author Message
hemantgaur



Joined: 16 Dec 2009
Posts: 20

PostPosted: Wed Aug 25, 2010 9:12 pm    Post subject: Out of Disk space Reply with quote

I am comparing around 70-80 tables. Tables have huge volume of data and I know the differences are of huge as well. The statement "session.CompareDatabases" executes for around 15 minutes. While it is executing, I notice my disk space in C drive continuously reduces. And eventually runs out of disk space and throws an IO exception and terminates.

Is there a way to force Red gate to write the temp files that it is writing to my D: drive? It would take me a long time to ready a bigger C drive, but would be easier to just add another drive, call it D, and point red gate to write to it.

Please help. This is an urgent issue and stopping us from testing any further.
Back to top
View user's profile Send private message
simon.jackson



Joined: 08 Jan 2009
Posts: 45

PostPosted: Thu Aug 26, 2010 3:59 pm    Post subject: Reply with quote

Hey, there's a couple of things you can do.

In order to choose the location of all temporary files for red gate products you can set the RGTEMP variable. This is described in full here
http://www.red-gate.com/supportcenter/Content.aspx?p=SQL%20Data%20Compare&c=knowledgebase\SQL_Data_Compare\KB200810000312.htm


You can also turn on "compress temporary files" in the data compare options. There is a slight downside to this, in that you can't sort the results, but it will considerably reduce the disk usage.
Back to top
View user's profile Send private message
hemantgaur



Joined: 16 Dec 2009
Posts: 20

PostPosted: Thu Aug 26, 2010 5:00 pm    Post subject: Reply with quote

that worked perfectly. Though a reboot was required. So just wanted to add that.

Thank you Simon. You were a big help, TWICE in a day. Smile
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