https://community.hpe.com/t5/server-management-systems/sim-4-0-reducing-sql-database-size/m-p/3320759#M3980 By default, the database is installed with the full recovery model in SQL Server. You need either to program regular SQL Server transaction log backups, or move to "Simple" recovery model to gain back some of the log space. Fri, 09 Jul 2004 03:58:04 GMT Etienne Beureux 2004-07-09T03:58:04Z https://community.hpe.com/t5/server-management-systems/sim-4-0-reducing-sql-database-size/m-p/3320757#M3978 Our SIM database is gaining over 2.5 GB and I am looking for a method to shrink it?<BR /><BR />Shoudl we manually go into certain tables to delete data, or is there a method to remove old events from SIM?<BR /><BR />We currently have about 4500 events in SIM. Is it as simple as deleting many of these events then using SQL to shrink the database? Or is there a simply way inside SIM to take care of this? Thu, 01 Jul 2004 11:40:27 GMT https://community.hpe.com/t5/server-management-systems/sim-4-0-reducing-sql-database-size/m-p/3320757#M3978 Paul S._2 2004-07-01T11:40:27Z https://community.hpe.com/t5/server-management-systems/sim-4-0-reducing-sql-database-size/m-p/3320758#M3979 hello<BR /><BR />Remove old events with Delete Event tool. This tool delete events from a specific event list.<BR /><BR />i.<BR /> Fri, 02 Jul 2004 05:24:00 GMT https://community.hpe.com/t5/server-management-systems/sim-4-0-reducing-sql-database-size/m-p/3320758#M3979 Ivan KOVAC 2004-07-02T05:24:00Z https://community.hpe.com/t5/server-management-systems/sim-4-0-reducing-sql-database-size/m-p/3320759#M3980 By default, the database is installed with the full recovery model in SQL Server. You need either to program regular SQL Server transaction log backups, or move to "Simple" recovery model to gain back some of the log space. Fri, 09 Jul 2004 03:58:04 GMT https://community.hpe.com/t5/server-management-systems/sim-4-0-reducing-sql-database-size/m-p/3320759#M3980 Etienne Beureux 2004-07-09T03:58:04Z https://community.hpe.com/t5/server-management-systems/sim-4-0-reducing-sql-database-size/m-p/3320760#M3981 Thanks, I think it was the SQL logging size that got us. I put it to simple and shrank the database - looks much better.<BR /><BR />thanks for the tips Fri, 09 Jul 2004 08:16:42 GMT https://community.hpe.com/t5/server-management-systems/sim-4-0-reducing-sql-database-size/m-p/3320760#M3981 Paul S._2 2004-07-09T08:16:42Z