Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dixon520
Starting Member
3 Posts |
 Posted - 2008-07-31 : 07:24:38
|
| I'm in the process of imported some large VFP/dbase tables into SQL 2000. I must first give some background on the setup of the server I'm working with. Two HD's. Drive Size Free Spacec:\ 12GB 2.4GBd:\ 124GB 60GBUnfortunately, SQL Svr was installed on the c:\ which obviously has minimal space remaining. I setup the destination database for my VFP tables to be located on the d:\ which has plenty of space. I have now moved all databases (system and user db's) to the D:\ since tempdb was causing me to run out of disk space when executing the dts package I have setup. I've noticed though, that when first executing the dts package, before any rows start to process, at least a gb of space is used up on the c:\ drive. With that said, my question is why or what is using up the storage space on c:\ when all the system and user databases are now on the larger of the two drives? I checked the page file and it doesn't appear to grow while executing the package. Also, I see the same amount of disk space used when simply clicking on the transform elipse when selecting which tables I want to import. |
|
|
dixon520
Starting Member
3 Posts |
Posted - 2008-07-31 : 07:48:10
|
| Ok, so I've been trying to identify what exactly is using up the space on c:\ and I'm getting a little closer. I've found a tmp file located in C:\Documents and Settings\<user>\Local Settings\Temp which was created at the same time I started executing the DTS package. The file size has grown to nearly 2gb at this point. Is there any way change the default Temp directory for SQL Server ? |
 |
|
|
dixon520
Starting Member
3 Posts |
Posted - 2008-07-31 : 08:12:25
|
| Modifying the Temp Environment Variable takes care of this issue. See: [url]http://msdn.microsoft.com/en-us/library/ms174203.aspx[/url] |
|
|
|
|
|
|
DTS and Disk Space Issue