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 |
|
Ling
Starting Member
4 Posts |
 Posted - 2009-03-22 : 23:48:22
|
| Hi All, we have a database need to run several SQL SSIS packages to import a few million rows of data. How to minimize the log space that is used by import operations. I am not sure what should be the right thing to do of the followings: 1) In the Database Properties window, modify the option Auto Shrink, set to TRUE. 2) In the Database Properties window, set Recovery Model to "Bulk- logged"3) do both of the above. Could anybody inform which would the correct/perfect answer? Thank you, Ling |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-03-26 : 05:31:58
|
IMHODo NOT set Auto Shrink to true because each night the space will be allocated again.GreetingsWebfredEdit: PS removed 
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
Ling
Starting Member
4 Posts |
Posted - 2009-03-30 : 20:57:03
|
Hi Webfred, Yes, removed sensible info, thanks for letting me know :) Cheers, Ling ---------------quote:
Originally posted by webfred
IMHODo NOT set Auto Shrink to true because each night the space will be allocated again.GreetingsWebfredEdit: PS removed
No, you're never too old to Yak'n'Roll if you're too young to die.
|
|
|
|
|
|
|
|
|
minimize the log space