RemoveAlternateStreams - 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 2000 Forums

SQL Server Administration (2000)

RemoveAlternateStreams

Author

Topic

krishnarajeesh
Yak Posting Veteran

67 Posts

Posted - 2008-08-05 : 14:07:53

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.

Thanks,
Krishna

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-08-05 : 23:06:44

Check windows system event log, maybe disk related issue.

krishnarajeesh
Yak Posting Veteran

67 Posts

Posted - 2008-08-07 : 14:26:04

No errors on event log.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-08-07 : 22:23:27

Reboot server to see if cleans error.

krishnarajeesh
Yak Posting Veteran

67 Posts

Posted - 2008-08-08 : 16:01:43

nop, this error happens when the system restarts.

As per Paul Randal ,which I got from 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
www.SQLServer.in

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-08-08 : 23:51:43

Then you have diffenet issue since:

1. you can't create snapshot for master db, and
2. snapshot is a feature in sql2k5 enterprise edition, but you post in sql2k forum.

krishnarajeesh
Yak Posting Veteran

67 Posts

Posted - 2008-08-10 : 13:37:51

Oh Sorry...that was by mistake...
Will post in 2k5

Thanks,
Krishna

Thanks,
Krishna
www.SQLServer.in

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources