|
dr223
Constraint Violating Yak Guru
361 Posts |
 Posted - 10/13/2009 : 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 |
|
TempDB grows causing C drve to be FULL
