Database size - sound ok, best way to reduce ??

[snow-munki]

Hi,

Just upgraded to ePO 4.5 and noticed the SQL 2005 database size went from about 695 MB to 963 MB

Does this sound about right, have about 200 users.

If not what would the best way to reduce the database size ? Assume I can somehow delete logs or something ?

Thanks

[Artfulbodger · Accepted solution]

Hi.

You could create Purge Audit Log and Purge Event log tasks from the automation Section.  This can be sheduled to do the house keeping on your Server Event Logs for you.

This might help reduce the size of your database.  Failing that you could index and rebuild you SQL database uising the usual SQL tools.  But don't forget to back up you DB prior to doing any houskeeping outside of the ePO console.

Rich

[snow-munki]

Thanks very much, perfect !

[snow-munki]

Ok checked again this morning and it is now 1.3Gb !

Worried it is growing very quickly, anything we can do / check to reduce this ? Or is it perfectly normal ?