Thanks a lot for all your help Ekrem.
"Ekrem Önsoy" wrote:
> Brandon,
>
> Regarding to this message in your error log:
> SQL Server has encountered 1 occurrence(s) of cachestore flush for the
> 'Object Plans' cachestore (part of plan cache) due to some database
> maintenance or reconfigure operations.
>
> When the database is set to AUTOCLOSE = ON, an operation that initiates an
> automatic database shutdown clears the plan cache for the instance of SQL
> Server. Clearing the plan cache causes a recompilation of all subsequent
> execution plans and can cause a sudden, temporary decrease in query
> performance. In SQL Server 2005 Service Pack 2, for each cleared cachestore
> in the plan cache, the SQL Server error log contains the following
> informational message: "SQL Server has encountered %%d occurrence(s) of
> cachestore flush for the '%%s' cachestore (part of plan cache) due to some
> database maintenance or reconfigure operations". This message is logged
> every five minutes as long as the cache is flushed within that time
> interval.
> (
http://msdn.microsoft.com/en-us/library/ms174269.aspx)
>
> Other issue: FCB::RemoveAlternateStreams: Operating system error (null)
> occurred while creating or opening file 'C:\Program Files\Microsoft SQL
> Server\MSSQL.4\MSSQL\Data\Bagshaw200801_Data.MDF'. Diagnose and correct the
> operating system error, and retry the operation.
>
> According to my investigation, this error occurs when a backup, antivirus
> etc. software is installed on the SQL Server server and those products
> somehow causes this problem. So, I'll suggest you to revise your installed
> softwares and services which has a function like backup and antivirus
> softwares. OneCare (antivirus), LiveVault (backup software) etc. can cause
> this problem and its variations. Check out the Services MMC (start\run:
> services.msc) and task manager to see running processes to find a track this
> kind of softwares.
>
> This is all I can do, I hope it helps.
>
> --
> Ekrem Önsoy
>
>
>
> "Brandon"
discussions.microsoft.com> wrote in message
> news:0167BC7D-D896-4E78-B6FB-62F206E9695F@microsoft.com...>> Thanks for all your help Ekrem, even if your sugestion does not solve the
>> problem the logs will look a lot better untill I can find a proper
>> solution.
>>
>> I posed this Q to a lot of SQL admins and you have by far been the most
>> helpfull.
>> Thanks!
>>
>> "Ekrem Önsoy" wrote:
>>
>>> Well, I don't have anything to guess anymore. However you said that this
>>> is
>>> a SQL Server 2005 Express Edition. So, in this edition of SQL Server the
>>> "AutoClose" property is true by default. And because of this property,
>>> when
>>> the last connected user disconnects, your database is closed and all
>>> resources allocated for it is freed.
>>>
>>> I think you get this error when another user tries to connect to this
>>> database so it's opened again and you get this error somehow.
>>>
>>> If this database is being used frequently and if you have enough
>>> resources
>>> to allocated for this instance of SQL Server then how about setting this
>>> AutoClose property to False? You can find this property in that
>>> database's
>>> properties\Options.
>>>
>>> This just a suggestion, not a solution.
>>>
>>> --
>>> Ekrem Önsoy
>>>
>>>
>>>
>>> "Brandon"
discussions.microsoft.com> wrote in message
>>> news:D97F0409-1B63-4E7D-875B-354E6E49A78E@microsoft.com...>>>> Thanks again for your help.
>>>>
>>>> It is a member server and hosts two applications. One is a proprietary
>>>> applicaiton and the other is Trend Micro Interscan. It is also running
>>>> Trend
>>>> Micro Officescan as the antivirus software. Interscan is using a
>>>> database
>>>> on
>>>> a different instance and is not receiving mail as of yet, this still
>>>> has
>>>> to
>>>> be put into production. I unloaded officescan and restarted the
>>>> instance
>>>> and
>>>> the problem still occurs.
>>>>
>>>> I have been looking closely at this error and saw that it is not
>>>> actually
>>>> every hour, but when users start the software up a entry is placed in
>>>> the
>>>> event log "starting up database..." and thereafter this error is
>>>> logged.
>>>>
>>>> I have forwarded this to the support people of the proprietary software
>>>> but
>>>> anticipate them saying that it is a database problem and not related to
>>>> their
>>>> software.
>>>>
>>>> There are no scheduled jobs running on the server.
>>>>
>>>> Thanks again.
>>>>
>>>>
>>>>
>>>> "Ekrem Önsoy" wrote:
>>>>
>>>>> You said that you get this error "every hour" so this makes me think
>>>>> that
>>>>> there must be some Scheduled Job in SQL Server or Windows or another
>>>>> software that is executed and caused this error.
>>>>>
>>>>> Will you tell me what softwares are being run on this server where
>>>>> this
>>>>> SQL
>>>>> Server 2005 Express Edition is installed? For example, is this a
>>>>> Domain
>>>>> Controller at the same time? Or Exchange Server is installed? Or
>>>>> Antivirus
>>>>> softwares?
>>>>>
>>>>> Review your scheduled jobs that run every hour and let us know about
>>>>> them.
>>>>> So we may reach to some evidence about this error.
>>>>>
>>>>> --
>>>>> Ekrem Önsoy
>>>>>
>>>>>
>>>>>
>>>>> "Brandon"
discussions.microsoft.com> wrote in message
>>>>> news:5BABAB0B-F182-490F-A60E-1D269629AE38@microsoft.com...>>>>>> This is the error in the Windows Application event log. The error in
>>>>>> SQL
>>>>>> Manager looks the same.
>>>>>>
>>>>>>
>>>>>> "Ekrem Önsoy" wrote:
>>>>>>
>>>>>>> Do the Windows Event Logs say anything about this error?
>>>>>>>
>>>>>>> --
>>>>>>> Ekrem Önsoy
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> "Brandon"
discussions.microsoft.com> wrote in message
>>>>>>> news:2E2D2B01-4117-489B-A352-0FE1F1861DA8@microsoft.com...>>>>>>>> Thanks very much for your reply, I did look at this same post and
>>>>>>>> removed
>>>>>>>> the
>>>>>>>> SQL server installation and database fodlers from real time virus
>>>>>>>> scanning, I
>>>>>>>> just have not been able to restart the server as of yet. This
>>>>>>>> will
>>>>>>>> be
>>>>>>>> done
>>>>>>>> after business hours today.
>>>>>>>>
>>>>>>>> What did concern me a bit was the fact that this post refers to
>>>>>>>> operating
>>>>>>>> system error 6, and mine refers to operating system error null.
>>>>>>>>
>>>>>>>> We are running Trend Officescan Enterprise AV.
>>>>>>>>
>>>>>>>> Thanks for any other help that you may provide.
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> "Ekrem Önsoy" wrote:
>>>>>>>>
>>>>>>>>>> Hi all,
>>>>>>>>>>
>>>>>>>>>> I have a Windows server 2003 SP2 server that has one SQL 2005
>>>>>>>>>> SP2
>>>>>>>>>> instance
>>>>>>>>>> and one SQL Express 2005 instance installed.
>>>>>>>>>>
>>>>>>>>>> On one of my databases in the SQL express instance I am
>>>>>>>>>> getting
>>>>>>>>>> the
>>>>>>>>>> following error logged in the application event log about
>>>>>>>>>> every
>>>>>>>>>> hour,
>>>>>>>>>> although the database seems to be running fine.
>>>>>>>>>>
>>>>>>>>>> FCB::RemoveAlternateStreams: Operating system error (null)
>>>>>>>>>> occurred
>>>>>>>>>> while
>>>>>>>>>> creating or opening file 'C:\Program Files\Microsoft SQL
>>>>>>>>>> Server\MSSQL.4\MSSQL\Data\Bagshaw200801_Data.MDF'. Diagnose
>>>>>>>>>> and
>>>>>>>>>> correct
>>>>>>>>>> the
>>>>>>>>>> operating system error, and retry the operation.
>>>>>>>>>>
>>>>>>>>>> I cannot tell what is causing it, please could somebody help
>>>>>>>>>> me.
>>>>>>>>>>
>>>>>>>>>> Thank you in advance.
>>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>
>>>
>
