SIM DB Transaction Log Size

[richard_323]

How do I truncate the size of the SIM DB Transaction Log? Using SQL 2000 as the DB on a Win2000 machine. Log is currently 66+ GB

[Mikael Rönnbäck]

There's a thread on how to shrink the database and its log file in this forum, for more details just search backwards in the forum. In brief here's what you need to do

1. Ensure the database model is set to simple.
2. Enable the autoshrink option.
3. Automatically grow option for both the database and log file should be enabled as well as the unrestricted file growth.
4. Optionally create an automatic event to delete events older then e.g. 2 months
5. From within the SQL Enterprise Manager, select the SQL server database, then select to shrink only the transaction logs (selecting shrink on the entire database will not have any effect)

[richard_323]

Truncating and Shrinking fixed the SQL DB problem