Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2008
    Posts
    2

    Red face Unanswered: Urgent Help required--Error: 9003,Severity:20,State:1.

    Hi,

    I am using Microsoft SQL Server 2000 Desktop Engine (MSDE 2000). When I restart the SQL Service, it fails to do so. I have tried running the service in command prompt & got the following error:

    Error: 9003, Severity: 20, State: 1.
    Cannot recover the master database. Exiting.


    Kindly help as it is quite urgent & I can not afford to loose any data. Thanks.

  2. #2
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    do you have a recent backup?

  3. #3
    Join Date
    Jan 2008
    Posts
    2
    I do have backup but thats not recent. I stand a chance of loosing around 15 days data by using that backup.

  4. #4
    Join Date
    Nov 2005
    Posts
    122
    Quote Originally Posted by mukhijask
    I do have backup but thats not recent. I stand a chance of loosing around 15 days data by using that backup.
    Hopefully you will only need a backup of the master database since it is the one being reported as corrupt.

    Read about "Restoring master databases.." in BOL for instructions.

    You can also recreate the master database using the rebuildm.exe tool. Read more in BOL.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •