I know of a really indirect/long way of doing this, but you may not need to
do it in the first place. What settings do you have checked in...
Double-click on your database (Emerald, I'm assuming), then click on the
We have the following checked for our Emerald database:
Select into / Bulk copy
No checkpoint on recovery
Truncate log on checkpoint
The last one is probably the most important one for not letting the logs get
out of hand.
For reference, our Data size is 300MB (89MB avail.); our Log size is 50MB
(49.99MB avail). This is on a dual Pentium III 450 with 512MB RAM
(memory=180000 (360MB RAM); tempdb in ram=50MB). We have almost 700,000
records (99% stop records) in our Calls table and everything is still
running as smooth as silk.
Of course, I also have a nice SQL Server 7 box that's been sitting here for
months waiting for me to upgrade our 6.5 SP5a, but getting around to doing
that seems to be a bit of a problem.
For more information about this list (including removal) go to: