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>

On Oct 7, 6:50*am, Athena <Ath...@discussions.microsoft.com> wrote:
> 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.

[prashantJ]

Hello,

In order to resolve your issue please refer the following URL http://mywindowsblog.com/?p=638

Regards,
Prashant.J.