> 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>