Thread Info
  • State Verified Answer
  • Locked Locked
  • Replies 8 replies
  • Subscribers 1 subscriber
  • Views 3750 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

Mssql$Sophos in event logs

Gazza

I hope someone can help.

In my event logs on a windows server 2003 dc I am getting an informational message from Mssql$Sophos about every 5 minutes and it is filling the logs. Here is the message :

Event Type: Information
Event Source: MSSQL$SOPHOS
Event Category: (2)
Event ID: 2803
Date:  02/08/2010
Time:  12:36:48
User:  N/A
Computer: Description:
SQL Server has encountered 1 occurrence(s) of cachestore flush for the 'Bound Trees' cachestore (part of plan cache) due to some database maintenance or reconfigure operations.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

What i want to know is is there any way of stopping the message from appearing atall or atleast less frequent.

Thanks in advance

                      Gareth

:4322


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

    Hi Gareth,

    Can you break down the command and check if the following works...

    osql –E –S .\sophos

    If this short command fails and still returns the error regarding no user selected, make sure you type the command in manually rather than pasting from this page.  If the command does work you should see a new line in the command prompt showing...

    1>_

    Now type the following commands exactly as shown...

    use sophos4

    go

    exec sp_dboption @dbname='sophos4', @optname='autoclose'

    go

    exit

    Let me know how it goes.

    Lil

    :4373
Reply
  • 0

    Hi Gareth,

    Can you break down the command and check if the following works...

    osql –E –S .\sophos

    If this short command fails and still returns the error regarding no user selected, make sure you type the command in manually rather than pasting from this page.  If the command does work you should see a new line in the command prompt showing...

    1>_

    Now type the following commands exactly as shown...

    use sophos4

    go

    exec sp_dboption @dbname='sophos4', @optname='autoclose'

    go

    exit

    Let me know how it goes.

    Lil

    :4373
Children
No Data
Unfiltered HTML