Operating system error 32 - 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)

Operating system error 32

Author

Topic

mvanwyk
Yak Posting Veteran

99 Posts

Posted - 2007-09-10 : 04:10:13

Hi SQL TEAM

Can someone please assist, we have a Database roughly 10GB in size,

For the past 2 days now we get the following errors.
////////
FCB::Open failed: Could not open file D:\MSSQL.1\MSSQL\Data\Helpdesk.mdf for file number 1. OS error: 32(error not found).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
////////
FCB::Open: Operating system error 32(error not found) occurred while creating or opening file 'D:\MSSQL.1\MSSQL\Data\Helpdesk.mdf'. Diagnose and correct the operating system error, and retry the operation.

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

Can someone tell me what is causing this error?

mvanwyk
Yak Posting Veteran

99 Posts

Posted - 2007-09-10 : 04:51:25

Hi i also get this in the error log

BackupVirtualDeviceFile::RequestDurableMedia: Flush failure on backup device 'Legato#d6579c32-f804-4404-9396-180edb07eef9'. Operating system error 995(error not found).

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2007-09-10 : 22:24:21

Did you see any disk related error in windows event logs?

Zoroaster
Aged Yak Warrior

702 Posts

Posted - 2007-09-10 : 22:28:54

quote:
Originally posted by mvanwyk

Hi SQL TEAM

Can someone please assist, we have a Database roughly 10GB in size,

For the past 2 days now we get the following errors.
////////
FCB::Open failed: Could not open file D:\MSSQL.1\MSSQL\Data\Helpdesk.mdf for file number 1. OS error: 32(error not found).

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.
////////
FCB::Open: Operating system error 32(error not found) occurred while creating or opening file 'D:\MSSQL.1\MSSQL\Data\Helpdesk.mdf'. Diagnose and correct the operating system error, and retry the operation.

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

Can someone tell me what is causing this error?

Check out this article, it is from IBM but it may be applicable, especially the part about memtoleave settings, worth a try.

http://209.85.165.104/search?q=cache:dpIt7o9P6gcJ:www-1.ibm.com/support/docview.wss%3Fuid%3Dswg21156744+Operating+system+error+995&hl=en&ct=clnk&cd=3&gl=us

Future guru in the making.

RoyalSher
Yak Posting Veteran

95 Posts

Posted - 2007-09-11 : 01:48:14

Here is my 2 cents.

I have a feeling that your database HelpDesk has AutoClose option set to True. And when SQL Server is trying to open the data file, the SQL processes finds that the .mdf file is being held up by some other process.

What you can do is, to set the AutoClose Option to false and see if you get the errors again.

Thanks!

RoyalSher.
*********
The world is the great gymnasium where we come to make ourselves strong.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources