Thread Info
  • State Not Answered
  • Locked Locked
  • Replies 4 replies
  • Subscribers 1 subscriber
  • Views 1637 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

Sophos Database

tedz

Hi,

How to Compaq a Sophos Database bec. it reach the maximum level of the express sql 4 gb.

can any one help us......

Thanks,

Teddy

:23163


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

    HI,

    If you're really struggling you could upgrade it to SQL Express 2008 R2, that has a 10GB limit but as Christian says, it can probably be solved as there is no need for it to be using that much space.

    The first thing I would do is from SQL Server Management Studio, connect to the SQL instance and run the built in report (right click on the database) and choose : Reports - Standard Reports - Disk Usage by Table.

    It may well turn out to be all firewall alerts for example.  PurgeDB.exe then might prove useful based on the outcome.
     

    Jak

    :23203
Reply
  • 0

    HI,

    If you're really struggling you could upgrade it to SQL Express 2008 R2, that has a 10GB limit but as Christian says, it can probably be solved as there is no need for it to be using that much space.

    The first thing I would do is from SQL Server Management Studio, connect to the SQL instance and run the built in report (right click on the database) and choose : Reports - Standard Reports - Disk Usage by Table.

    It may well turn out to be all firewall alerts for example.  PurgeDB.exe then might prove useful based on the outcome.
     

    Jak

    :23203
Children
No Data