MSSQLEXPRESS Operating system error 2

[Skipper]

Hi there, this forum helped me a lot on various topics. However this time I have some interesting issues. My event event viewer is leteraly screaming. Anyway here is one of the most common errors.

FileMgr::StartLogFiles: Operating system error 2(failed to retrieve text for this error. Reason: 15105) occurred while creating or opening file 'e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\MSDBLog.ldf'. Diagnose and correct the operating system error, and retry the operation

FCB::Open failed: Could not open file e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\MSDBData.mdf for file number 1. OS error: 21(failed to retrieve text for this error. Reason: 15105).

The SQL Server (SQLEXPRESS) service terminated with service-specific error The specified resource name cannot be found in the image file..

This is for the volmgr
Crash dump initialization failed!

BODY{font:x-small 'Verdana';margin-right:1.5em} .c{cursor:hand} .b{color:red;font-family:'Courier New';font-weight:bold;text-decoration:none} .e{margin-left:1em;text-indent:-1em;margin-right:1em} .k{margin-left:1em;text-indent:-1em;margin-right:1em} .t{color:#990000} .xt{color:#990099} .ns{color:red} .dt{color:green} .m{color:blue} .tx{font-weight:bold} .db{text-indent:0px;margin-left:1em;margin-top:0px;margin-bottom:0px;padding-left:.3em;border-left:1px solid #CCCCCC;font:small Courier} .di{font:small Courier} .d{color:blue} .pi{color:blue} .cb{text-indent:0px;margin-left:1em;margin-top:0px;margin-bottom:0px;padding-left:.3em;font:small Courier;color:#888888} .ci{font:small Courier;color:#888888} PRE{margin:0px;display:inline} - <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
- <System>
<Provider Name="EventLog" />

<EventID Qualifiers="32768">6008</EventID>

<Level>2</Level>

<Task>0</Task>

<Keywords>0x80000000000000</Keywords>

<TimeCreated SystemTime="2010-08-13T13:30:54.000000000Z" />

<EventRecordID>15024</EventRecordID>

<Channel>System</Channel>

<Computer>TheBlackPearl</Computer>

<Security />

</System>


- <EventData>
<Data>12:59:00</Data>

<Data>‎13/‎08/‎2010</Data>

<Data />

<Data />

<Data>19991</Data>

<Data />

<Data />

<Binary>DA07080005000D000C003B000000AF03DA07080005000D000B003B000000AF03600900003C000000010000006009000000000000B0040000010000009C040000</Binary>

</EventData>


</Event>

 

[Capt.Jack Sparrow]

Hello ! Welcome to SF !

I think the Operating System 2 error is "The system cannot find the file specified." seems like either that LDF file is missing or corrupted. Go to that location and see if that file is present there. I think it's best to reinstall SQL that could fix this problem. Does you use SQL Server for Database service or some other Program uses that instance ?

- Captain

 

[Skipper]

Thanks a lot Captain,

I will try to reinstall the sql, however may I ask you to give me a link where I can download it. Thanks again.

 

[Capt.Jack Sparrow]

Thanks a lot Captain,

I will try to reinstall the sql, however may I ask you to give me a link where I can download it. Thanks again.

Hello,

Here Download details: SQL Server 2005 Express Edition SP3

SQL Server 2008 R2 Express - Installation Options

- Captain

 

[Skipper]

Thanks Captain,
I will download the file and post my results later. Thank you so much for your prompt and accurate response.

 

[Capt.Jack Sparrow]

Thanks Captain,
I will download the file and post my results later. Thank you so much for your prompt and accurate response.

No problem ! Glad i could help

 

[Skipper]

Dear Captain,
I tried to reinstall the SQL, however the errors continue to pop up in the eventvewer.

I receive this error massage.

FCB::Open failed: Could not open file e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\MSDBData.mdf for file number 1. OS error: 21(failed to retrieve text for this error. Reason: 15105).

 

[Capt.Jack Sparrow]

Dear Captain,
I tried to reinstall the SQL, however the errors continue to pop up in the eventvewer.

I receive this error massage.

FCB::Open failed: Could not open file e:\sql10_main_t\sql\mkmastr\databases\objfre\i386\MSDBData.mdf for file number 1. OS error: 21(failed to retrieve text for this error. Reason: 15105).

Hello,

Try this article Error message when you try to upgrade to SQL Server 2008: "Wait on the Database Engine recovery handle failed"

- Captain