SIM 4.0 reducing SQL database size

[Paul S._2]

Our SIM database is gaining over 2.5 GB and I am looking for a method to shrink it?

Shoudl we manually go into certain tables to delete data, or is there a method to remove old events from SIM?

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?

[Ivan KOVAC]

hello

Remove old events with Delete Event tool. This tool delete events from a specific event list.

i.

[Etienne Beureux]

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.

[Paul S._2]

Thanks, I think it was the SQL logging size that got us. I put it to simple and shrank the database - looks much better.

thanks for the tips