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

Suggested SQL maintenance tasks on SOPHOS45 DB?

RL

Hi,

We've been experiencing a few issues with SEC and I was advised that this could be due to the lack of maintenance tasks on our SOPHOS45 DB.

We have a remote SQL 2005 SP2 server (SQL Server 9.0.3080), with the SOPHOS45 database running alongside other DB's in the DEFAULT instance.

At the moment we don't perform any maintenance tasks on the SOPHOS45 DB and wondered what (if any) are the official Sophos documented recommendations for the SQL maintenance tasks on the SOPHOS45 DB, and if any what order these should be performed in?

If there are no official documented recommendations then what tasks does the community run and in what order, how frequent etc.

Numbers wise we are talking sub 200 clients. Currently our SOPHOS45  DB is 58Mb and the logs are 290MB. Both located on seperate drives, etc..

Thanks,

John

:4471


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

    Well the Management service has't failed for a while now, but I can't confirm that this is due to the SQL maintenance tasks.

    However the problem with the end-points being stuck in the errors section is still there. I've now had my case moved from the US support office to the UK office under a new case ID.

    I'm still concered about the order of the maintenance tasls as I've heard that an incorrect order of SQL maintenance tasks can have a negative effect on some database's.

    When I asked Sophos about the official recommended maintenance tasks for the SOPHOS45 DB I was advised to run the following:


    Backup Database

    Check Database Integrity

    Shrink Database
    Reorganise Index
    Rebuild Index
    Update Statistics

    However I'm still unsure about the ORDER these tasks should  be run in. Sophos could not enlighten me either.

    Thanks,

    John

    :4619
Reply
  • 0

    Well the Management service has't failed for a while now, but I can't confirm that this is due to the SQL maintenance tasks.

    However the problem with the end-points being stuck in the errors section is still there. I've now had my case moved from the US support office to the UK office under a new case ID.

    I'm still concered about the order of the maintenance tasls as I've heard that an incorrect order of SQL maintenance tasks can have a negative effect on some database's.

    When I asked Sophos about the official recommended maintenance tasks for the SOPHOS45 DB I was advised to run the following:


    Backup Database

    Check Database Integrity

    Shrink Database
    Reorganise Index
    Rebuild Index
    Update Statistics

    However I'm still unsure about the ORDER these tasks should  be run in. Sophos could not enlighten me either.

    Thanks,

    John

    :4619
Children
No Data