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 |
dr223
Constraint Violating Yak Guru
444 Posts |
Posted - 2009-10-13 : 11:41:58
|
Hallo, I am working with Sql server 2005, I am trying to download a large table of over 100 million records. I have stored the database where the table is downloaded in my E drive so space on this perspective is sorted. However, when I use the import and export wizard the tempDB (stored in the C drive)grows rapidly and completes the 23.1 GB space available before the table is dowloaded from a flat file. It has been set to simple but still the growth is immense and it crashes before the flat file is downloaded. When I restart the server the tempdb reduces in size again. Is there anyway I can manage to reduce the size of the tempdb while the table is being downloaded? Or any ideas?Thanks |
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|