Go into SQL Enterprise Manager
Go to the listing of databases and double-click on Emerald
What are the following?:
Data space available
Log space available
Click on the Options tab. Do you have "Truncate Log on Checkpoint"
checked? That'll keep the log from getting out of hand.
If you do a lot of transactions in a short period of time, you may need to
manually "truncate log" (button under the "Databases" tab).