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

    Hi yah QC,

    We have two issues at the moment:

    1. The Sophos Management Service fails now and then. We have up to 5 consoles running at one time. (1 on a plasma monitoring the whole estate, 2 used for day-to-day ops on internal systems, and another 2 used by a team that manage an external sub estate). Although most of the time we'll have 2 or 3 running at any one given time.

    2. Machines stuck in the computers with errors section in SEC. - We basically have a handful of machines that had errors which were cleared, however after a reboot of the clients, reboot of the server, running PURGEDB, etc, the machines are still stuck in the computers with errors section.

    Both have support cases open, both have been suggested that the database is the cause due to lack of maintenance tasks.

    Thus the reasons for the question on suggested SQL maintenance tasks. Since my post I found the following online article: http://www.networkworld.com/subnets/microsoft/110107-ch8-sql-server.html?page=3 and have set some maintenance tasks to run on Sunday evening.

    We'll see how this pans out on Monday I guess.

    Thanks,

    John

    :4479
Reply
  • 0

    Hi yah QC,

    We have two issues at the moment:

    1. The Sophos Management Service fails now and then. We have up to 5 consoles running at one time. (1 on a plasma monitoring the whole estate, 2 used for day-to-day ops on internal systems, and another 2 used by a team that manage an external sub estate). Although most of the time we'll have 2 or 3 running at any one given time.

    2. Machines stuck in the computers with errors section in SEC. - We basically have a handful of machines that had errors which were cleared, however after a reboot of the clients, reboot of the server, running PURGEDB, etc, the machines are still stuck in the computers with errors section.

    Both have support cases open, both have been suggested that the database is the cause due to lack of maintenance tasks.

    Thus the reasons for the question on suggested SQL maintenance tasks. Since my post I found the following online article: http://www.networkworld.com/subnets/microsoft/110107-ch8-sql-server.html?page=3 and have set some maintenance tasks to run on Sunday evening.

    We'll see how this pans out on Monday I guess.

    Thanks,

    John

    :4479
Children
No Data