Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 2 replies
  • Subscribers 1 subscriber
  • Views 9688 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.
  • 0

    Hi,

    I would suggest installing SQL Server Management Studio and run a report on the SOPHOS521 database such as:"Disk Usage by Table".

    See which table contains the majority of events.  I suspect it's the Firewall Events if you are managing SCF?  Post the output here if you like.

    Regards,

    Jak

    :53673
  • 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