https://community.hpe.com/t5/server-management-systems/sim-db-transaction-log-size/m-p/4869368#M44513 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<BR /><BR />1. Ensure the database model is set to simple.<BR />2. Enable the autoshrink option. <BR />3. Automatically grow option for both the database and log file should be enabled as well as the unrestricted file growth.<BR />4. Optionally create an automatic event to delete events older then e.g. 2 months<BR />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)<BR /> Mon, 08 Nov 2004 07:59:52 GMT Mikael Rönnbäck 2004-11-08T07:59:52Z https://community.hpe.com/t5/server-management-systems/sim-db-transaction-log-size/m-p/4869367#M44512 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 Mon, 08 Nov 2004 07:38:15 GMT https://community.hpe.com/t5/server-management-systems/sim-db-transaction-log-size/m-p/4869367#M44512 richard_323 2004-11-08T07:38:15Z https://community.hpe.com/t5/server-management-systems/sim-db-transaction-log-size/m-p/4869368#M44513 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<BR /><BR />1. Ensure the database model is set to simple.<BR />2. Enable the autoshrink option. <BR />3. Automatically grow option for both the database and log file should be enabled as well as the unrestricted file growth.<BR />4. Optionally create an automatic event to delete events older then e.g. 2 months<BR />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)<BR /> Mon, 08 Nov 2004 07:59:52 GMT https://community.hpe.com/t5/server-management-systems/sim-db-transaction-log-size/m-p/4869368#M44513 Mikael Rönnbäck 2004-11-08T07:59:52Z https://community.hpe.com/t5/server-management-systems/sim-db-transaction-log-size/m-p/4869369#M44514 Truncating and Shrinking fixed the SQL DB problem Mon, 08 Nov 2004 12:22:12 GMT https://community.hpe.com/t5/server-management-systems/sim-db-transaction-log-size/m-p/4869369#M44514 richard_323 2004-11-08T12:22:12Z