PC Review


Reply
Thread Tools Rate Thread

MSSMLBIZ cannot start Error 3417

 
 
Athena
Guest
Posts: n/a
 
      7th Oct 2008
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>

 
Reply With Quote
 
 
 
 
Luther
Guest
Posts: n/a
 
      10th Oct 2008
On Oct 7, 6:50*am, Athena <(E-Mail Removed)> 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.
 
Reply With Quote
 
 
 
 
New Member
Join Date: Sep 2011
Posts: 1
 
      4th Sep 2011
Hello,

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

Regards,
Prashant.J.
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
MSSMLBIZ will not start after a Windows XP Repair tps_art Microsoft Outlook BCM 4 31st Mar 2010 05:12 AM
I cannot Start SQL Server (MSSMLBIZ) service-specific error code Core20 Microsoft Outlook BCM 0 31st Dec 2009 04:49 PM
Cannot Start SQL Server (MSSMLBIZ) docharv Microsoft Outlook BCM 0 4th Dec 2008 11:55 PM
MSSMLBIZ cannot start error 3417 Athena Microsoft Outlook BCM 3 16th Nov 2008 02:08 AM
Update query giving runtime error 3417 action query cannot be used C0rrinn3 Microsoft Access VBA Modules 5 13th Aug 2008 01:36 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:56 PM.