Alternate streams Issue - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Alternate streams Issue

Author

Topic

krishnarajeesh
Yak Posting Veteran

67 Posts

Posted - 2008-08-10 : 13:41:27

Hi ,

Error: 17207, Severity: 16, State: 1

FCB::RemoveAlternateStreams: Operating system error (null) occurred while creating or opening file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf'. Diagnose and correct the operating system error, and retry the operation.

Any idea what this error implies. Iam getting this error whenever sql server restarts, for master & other databases too.

As per Paul Randal ,which I got googling.......

This is a startup procedure that removes any alternate streams from database files. Alternate streams are used by the database snapshot feature when no alternative snapshot location is specified, or when one of the DBCC CHECK* commands are run.

But am not sure since I dont have a snapshot or didnt run any DBCC CHECK.

Thanks,
Krishna

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-08-10 : 16:54:47

>> I am getting this error whenever sql server restarts

What's your sql2k5 edition? Does sql start?

krishnarajeesh
Yak Posting Veteran

67 Posts

Posted - 2008-08-12 : 12:53:58

Microsoft SQL Server 2005 - 9.00.3159.00 (Intel X86) .

SQL started and working properly

Thanks,
Krishna
www.SQLServer.in

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-08-12 : 23:15:38

Take look at this link:

http://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=246341

krishnarajeesh
Yak Posting Veteran

67 Posts

Posted - 2008-08-15 : 16:12:24

Hi ,

Thanks for the link. I got the same information from some other link & in which it is mentioned like
some antivirus softwares may create this issue. But I have McAfee 3.6 version which is not in the list. May be I will have to check all the installed softwares in the system.

Thanks,
Krishna

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources