sql server dts: I have a dts package that updates a database each
day. The db has about 8 million records, and
the updates affect about 200,000 records. I
am wondering how often, if at all, I should
use the shrinkdatabase command? I have already
coded the command into the dts package, but it takes so
long. Am I doing this unneccessarily? Is there

Whay do you need to shrink the DB every time the package is run ?

I generally size my DB at the start so I have 6-12 months growth. From then
on I allow for ~ 2 months growth at a time.

Is it the log that is ballooning? If it is then look to take regular
backups of it / or use SIMPLE recovery mode and look to break large
operations into batches.


--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



[quoted text, click to view]