Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 1 subscriber
  • Views 9687 views
  • Users 0 members are here
Options
Suggested
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Database reached maximum 10240 mb

coblentz

Management Server 5.2.1 on Win 2008 is showing this message in its Event viewer

"...because the resulting cumulative database size would exceed your licensed limit of 10240 MB per database."

I have only 200 nodes so I don't know why the database would have grown so large.

I don't want to switch to full blown SQL since I feel SQL Express should be able to handle 200 nodes.

Are there maintenance steps to clean up old data?

Further, what steps are there to prevent this from happening again?

:53671


This thread was automatically locked due to age.
Parents
  • 0

    Thanks.

    What I ended up doing was to change the number of months  in thePurge setting under Tools > Configure Reporting.

    In my case, I was rather aggressive and changed it from 12 to 1 month.

    Then I ran purgedb.exe located in:

    C:\Program Files\Sophos\Enterprise Console

    Last step was to backup the db and shrink it.  The result is a 3 gig database and the console runs much faster.

    I think you're right that it's the firewall events.  Is there a way to control what gets logged?

    :53677
Reply
  • 0

    Thanks.

    What I ended up doing was to change the number of months  in thePurge setting under Tools > Configure Reporting.

    In my case, I was rather aggressive and changed it from 12 to 1 month.

    Then I ran purgedb.exe located in:

    C:\Program Files\Sophos\Enterprise Console

    Last step was to backup the db and shrink it.  The result is a 3 gig database and the console runs much faster.

    I think you're right that it's the firewall events.  Is there a way to control what gets logged?

    :53677
Children
No Data