cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

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

Jump to solution

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

1 Solution

Accepted Solutions

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

Jump to 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

3 Replies

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

Jump to 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

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

Jump to solution

Thanks very much, perfect !

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

Jump to solution

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 ?

More McAfee Tools to Help You

Community Help Hub

    New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

  • Find Forum FAQs
  • Learn How to Earn Badges
  • Ask for Help
Go to Community Help

Join the Community

    Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

  • Get helpful solutions from McAfee experts.
  • Stay connected to product conversations that matter to you.
  • Participate in product groups led by McAfee employees.
Join the Community
Join the Community