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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-04-06 : 08:46:54
|
| Paul writes "I am new to SQL Server so I appologize for the verry elementary question.when I import a flat file (5 Megabyte text file) to a table in my db, the db grows upto 20 megabytes in size? I have run the shrink utility can anyone give some insight on this?SQL Server 2000 XP ProfessionalThank you very much in advance.Paul" |
|
|
mfemenel
Professor Frink
1421 Posts |
Posted - 2005-04-06 : 09:28:39
|
| Check out the database recovery model. Most likely you have it set to full. You might consider changing this to Bulk-Logged which will only minimally log the bulk operations. Check out books on line under the topic "recovery models" and read up on "selecting a recovery model" to see the ins and outs of each model and whether or not you should do this.Mike"oh, that monkey is going to pay" |
 |
|
|
|
|
|
Importing flat files and db size