MSSMLBIZ cannot start Error 3417


A

Athena

Hello,
My CBM recently stopped working. I tried to start the service from
service manager, SQL Server Configuration Manager. The event viewer reports
the following error. How can I rebuild/repair the database without loosing
data and strat the service? Thank you.

Athena

"Log Name: Application
Source: MSSQL$MSSMLBIZ
Date: 10/7/2008 9:38:41 AM
Event ID: 9003
Task Category: (2)
Level: Error
Keywords: Classic
User: N/A
Computer: Biopticon-3
Description:
The log scan number (230:488:1) passed to log scan in database 'master' is
not valid. This error may indicate data corruption or that the log file
(.ldf) does not match the data file (.mdf). If this error occurred during
replication, re-create the publication. Otherwise, restore from backup if the
problem results in a failure during startup.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="MSSQL$MSSMLBIZ" />
<EventID Qualifiers="49152">9003</EventID>
<Level>2</Level>
<Task>2</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2008-10-07T13:38:41.000Z" />
<EventRecordID>113719</EventRecordID>
<Channel>Application</Channel>
<Computer>Biopticon-3</Computer>
<Security />
</System>
<EventData>
<Data>(230:488:1)</Data>
<Data>master</Data>

<Binary>2B2300001400000015000000420049004F0050005400490043004F004E002D0033005C004D00530053004D004C00420049005A00000000000000</Binary>
</EventData>
</Event>
 
Ad

Advertisements

L

Luther

Hello,
       My CBM recently stopped working. I tried to start the service from
service manager, SQL Server Configuration Manager. The event viewer reports
the following error. How can I rebuild/repair the database without loosing
data and strat the service? Thank you.

Athena

"Log Name:      Application
Source:        MSSQL$MSSMLBIZ
Date:          10/7/2008 9:38:41 AM
Event ID:      9003
Task Category: (2)
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      Biopticon-3
Description:
The log scan number (230:488:1) passed to log scan in database 'master' is
not valid. This error may indicate data corruption or that the log file
(.ldf) does not match the data file (.mdf). If this error occurred during
replication, re-create the publication. Otherwise, restore from backup ifthe
problem results in a failure during startup.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="MSSQL$MSSMLBIZ" />
    <EventID Qualifiers="49152">9003</EventID>
    <Level>2</Level>
    <Task>2</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2008-10-07T13:38:41.000Z" />
    <EventRecordID>113719</EventRecordID>
    <Channel>Application</Channel>
    <Computer>Biopticon-3</Computer>
    <Security />
  </System>
  <EventData>
    <Data>(230:488:1)</Data>
    <Data>master</Data>

<Binary>2B2300001400000015000000420049004F0050005400490043004F004E002D00330­05C004D00530053004D004C00420049005A00000000000000</Binary>
  </EventData>
</Event>
If no one answers here, I'd recommend asking in a sql server
newsgroup. They'll have more expertise in this area.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top