FCB::RemoveAlternateStreams: Operating system error (null)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Brandon - 25 Jul 2008 08:12 GMT

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.

Reply to this Message

Ekrem Önsoy - 25 Jul 2008 09:14 GMT

Hello Brandon,

Take a look at the following link:
http://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=181344&SiteID=17

Signature

Ekrem Önsoy

> Hi all,
>
[quoted text clipped - 14 lines]
>
> Thank you in advance.

Reply to this Message

Brandon - 25 Jul 2008 09:50 GMT

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.

> Hello Brandon,
>
[quoted text clipped - 19 lines]
> >
> > Thank you in advance.

Reply to this Message

Ekrem Önsoy - 25 Jul 2008 11:29 GMT

Do the Windows Event Logs say anything about this error?

Signature

Ekrem Önsoy

> Thanks very much for your reply, I did look at this same post and removed
> the
[quoted text clipped - 35 lines]
>> >
>> > Thank you in advance.

Reply to this Message

Brandon - 25 Jul 2008 12:33 GMT

This is the error in the Windows Application event log. The error in SQL
Manager looks the same.

> Do the Windows Event Logs say anything about this error?
>
[quoted text clipped - 37 lines]
> >> >
> >> > Thank you in advance.

Reply to this Message

Ekrem Önsoy - 25 Jul 2008 18:39 GMT

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.

Signature

Ekrem Önsoy

> This is the error in the Windows Application event log. The error in SQL
> Manager looks the same.
[quoted text clipped - 45 lines]
>> >> >
>> >> > Thank you in advance.

Reply to this Message

Brandon - 26 Jul 2008 07:39 GMT

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.

> 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
[quoted text clipped - 57 lines]
> >> >> >
> >> >> > Thank you in advance.

Reply to this Message

Ekrem Önsoy - 26 Jul 2008 09:09 GMT

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.

Signature

Ekrem Önsoy

> Thanks again for your help.
>
[quoted text clipped - 91 lines]
>> >> >> >
>> >> >> > Thank you in advance.

Reply to this Message

Brandon - 27 Jul 2008 08:28 GMT

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!

> 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
[quoted text clipped - 107 lines]
> >> >> >> >
> >> >> >> > Thank you in advance.

Reply to this Message

Ekrem Önsoy - 27 Jul 2008 10:16 GMT

Can you send me the SQL Error Log which contains this error? My email
address is "ekrem AT compecta DOT com".

Maybe we can find something there.

Signature

Ekrem Önsoy

> 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
[quoted text clipped - 134 lines]
>> >> >> >> >
>> >> >> >> > Thank you in advance.

Reply to this Message

Ekrem Önsoy - 28 Jul 2008 09:03 GMT

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.

Signature

Ekrem Önsoy

Reply to this Message

Brandon - 29 Jul 2008 12:31 GMT

Thanks a lot for all your help Ekrem.

> Brandon,
>
[quoted text clipped - 170 lines]
> >> >> >> >> >
> >> >> >> >> > Thank you in advance.

Reply to this Message