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

    Hi,

    If I remember correctly and I might not :), the wizard that you can use to create a maintenance plan asks if you want to run these as separate tasks or as one.  If you choose to do it as a single task I would think the wizard would set them up in the most appropriate order.  It's really a generic database tasks and not specific to Sophos products so I would suggest let the wizard do his thing. :)

    Thanks,

    Jak

    :4627
Reply
  • 0

    Hi,

    If I remember correctly and I might not :), the wizard that you can use to create a maintenance plan asks if you want to run these as separate tasks or as one.  If you choose to do it as a single task I would think the wizard would set them up in the most appropriate order.  It's really a generic database tasks and not specific to Sophos products so I would suggest let the wizard do his thing. :)

    Thanks,

    Jak

    :4627
Children
No Data