SQL Server Performance

Cant start SQL server service

Discussion in 'General DBA Questions' started by Akthar, Jan 22, 2007.

  1. Akthar New Member

    hi guys ,
    i am having the following error when starting SQL server service:
    Event Type: Error

    Event Source: MSSQL$SQL_2000

    Event Category: (2)

    Event ID: 17055

    Date: 22/01/2007

    Time: 3:38:06 PM

    User: N/A

    Computer: SQLServer1

    Description:

    18052 :

    Error: 9003, Severity: 20, State: 1.
    For more information, see Help and Support Center athttp://go.microsoft.com/fwlink/events.asp.

    Data:

    0000: 84 46 00 00 10 00 00 00 „F......

    0008: 10 00 00 00 4a 00 4d 00 ....J.M.

    0010: 41 00 52 00 49 00 45 00 A.R.I.E.

    0018: 5c 00 53 00 51 00 4c 00 .S.Q.L.

    0020: 5f 00 32 00 30 00 30 00 _.2.0.0.

    0028: 30 00 00 00 07 00 00 00 0.......

    0030: 6d 00 61 00 73 00 74 00 m.a.s.t.

    0038: 65 00 72 00 00 00 e.r...


    AKTHAR
  2. jsuessmeyer New Member

    Hi,

    there should be some more inforamtion about the error. Looks like the master database became corrupted. Before searching for the basic error (which is often relataed to physical problems) I would suggest you to backup the database on the server (if not done yet). This is just for the case that you have a physical failure on your harddrives. Afterwards I would try to restore a valid recent master database backup and see if the database is running again. Make sure to scan your harddrives ASAP for physical failures !

    HTH, Jens K. Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---

    HTH, Jens K. Suessmeyer.

    ---
    http://www.sqlserver2005.de
    ---
  3. Akthar New Member

    yep its a problem with the master db. unfortunately i havt got a backup of the master db for this server as it is a dev server. I guess i will have to re-install and restore the data

    thanks

    AKTHAR
  4. dineshasanka Moderator

    you have to take master server even it is a development server

    ----------------------------------------
    Contributing Editor, Writer & Forums Moderator
    http://www.SQL-Server-Performance.Com

    Visit my Blog at
    http://dineshasanka.spaces.live.com/

Share This Page