Here's part 2, from a message I sent to the list sometime last year:
Go into SQL Enterprise Manager
Click on the "+" next to your SQL server name.
Right-click on Database Devices and choose New Device.
Name: EmeraldLogs (or whatever you want)
Size: ?? (mine is 35MB but 99% of the time, only about 1MB is
being used because I have the Transaction Log
"truncate on checkpoint" each night at 3:15am when the
database is backed up (diskdump))
Click on Create Now
Click on the "+" next to Databases
Double-click on Emerald
Click on Expand
Data Device: (none)
Log Device: EmeraldLogs (or whatever you named it above)
Size: (same as the value you selected above)
Click on Expand Now
Click on the Options tab.
Check "Truncate Log on Checkpoint" to keep the logs small.
Note: by doing this, you won't be able to backup the
transaction logs when doing a diskdump (backup).
Click Ok.
I don't remember if you have to stop/restart MSSQL service or not.
This will prevent your transaction logs from causing problems with running
out of space for your data.
Josh
For more information about this list (including removal) go to:
http://www.iea-software.com/support/maillists/liststart