asked on

MSSQL Server will not start

Hi,
When I came to work this morning, I could not log-in to my SharePoint 3.0 server. The SQL Server holding the SharePoint 3.0 content and configuration will not start. I have attached the error messages from the Event viewer.

We uses this service a lot and can't make to work since 12 hourg back. Please help.

-aj

Log Name:      Application
Source:        MSSQL Server
Date:          11/17/2009 11:56:07 PM
Event ID:      3417
Task Category: (2)
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      ServerName
Description:
Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="MSSQL Server" />
    <EventID Qualifiers="49152">3417</EventID>
    <Level>2</Level>
    <Task>2</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2009-11-17T23:56:07.000Z" />
    <EventRecordID>50213</EventRecordID>
    <Channel>Application</Channel>
    <Computer>computerName</Computer>
    <Security />
  </System>
  <EventData>
    <Binary>590D00000A000000050000004D00410052005300000000000000</Binary>
  </EventData>
</Event>
 
 
Second Error Message
 
Log Name:      Application
Source:        MSSQL Server
Date:          11/17/2009 11:56:07 PM
Event ID:      9003
Task Category: (2)
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      ComputerName
Description:
The log scan number (440:400: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 Server" />
    <EventID Qualifiers="49152">9003</EventID>
    <Level>2</Level>
    <Task>2</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2009-11-17T23:56:07.000Z" />
    <EventRecordID>50212</EventRecordID>
    <Channel>Application</Channel>
    <Computer>ComputerName</Computer>
    <Security />
  </System>
  <EventData>
    <Data>(440:400:1)</Data>
    <Data>master</Data>
    <Binary>2B23000014000000050000004D00410052005300000000000000</Binary>
  </EventData>
</Event>

Open in new window

Anthony Perkins

>>Cannot recover the master database. SQL Server is unable to run. Restore master from a full backup, repair it, or rebuild it. For more information about how to rebuild the master database, see SQL Server Books Online.<<

So you do not have a backup and/or are not prepared to restore from a backup?

Atouray

ASKER

I would prefer to do a repair if there will be no data lost.

geek_vj

From the error message, it looks like the master database got corrupt. Please try to repair it using rebuildm.exe utility as it is SQL Server 2000 box.

Atouray

ASKER

Its MSSQL 2005. How do i rebuild the database using an MSDN DVD?

Thanks for the reply.

ASKER CERTIFIED SOLUTION

Molnár István

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

san_spy

dont u have any master db backup? try restoring it once you rebuild the master.

Atouray

ASKER

Got it solved by myself - a backup restoration works for me.

Anthony Perkins

And that is exactly what I suggested you do.

geek_vj

Hi Atouray, MSSQL Server will not start - Thought its SQL 2000 box as the service name in SQL 2000 is MSSQL Service and in SQL 2005, it's SQL Server service.

Glad to know that backup and restore has worked for you.

Answering your question, rebuilding master database in SQL Server 2005 is a bit tricky and you should proceed through cmd prompt. Here are the steps:

Go the sql server configuration and change the properties to startup manual and stop the sql server services

Then run the command after changing to location where sql server media exists

start /wait setup.exe /qn INSTANCENAME= REINSTALL=SQL_Engine REBUILDDATABASE=1 SAPWD=

Default instance name is MSSQLSERVER

Again stop the sql server services and bring up the instance in single user mode by executing

sqlservr.exe -m ( Need to change directory to location where sql server was installed. generally it will be in D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Binn)

Now log on sql server management studio and restore the master database from backup. After the restore is completed,
error message will be displayed. Ignore this and close the management studio.

Start the sql server services from sql server configuration manager or from services in administration tools.

Hope this helps as reference in future.