Completed

Recover SQL instance from SQL Server 2000 - Corrupt Master Database

This project was successfully completed by elboukharimu for €105 EUR in 3 days.

Get free quotes for a project like this
Employer working
Completed by:
Project Budget
€50 - €150 EUR
Completed In
3 days
Total Bids
21
Project Description

Hi,

We have a server with Microsoft Windows Server 2000 (5.0, build 2195) with SQL Server 2000 installed. Due to hardware failure one SQL Server Instance got corrupted and now won't start. There seems to be an error with the master database so the applications that used to connect to this server instance remotely won't start anymore. The error message is:

2013-11-15 15:44:[url removed, login to view] server Microsoft SQL Server 2000 - [url removed, login to view] (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4)

2013-11-15 15:44:[url removed, login to view] server Copyright (C) 1988-2000 Microsoft Corporation.
2013-11-15 15:44:[url removed, login to view] server All rights reserved.
2013-11-15 15:44:[url removed, login to view] server Server Process ID is 1276.
2013-11-15 15:44:[url removed, login to view] server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL$COURIER\log\ERRORLOG'.
2013-11-15 15:44:[url removed, login to view] server SQL Server is starting at priority class 'normal'(1 CPU detected).
2013-11-15 15:44:[url removed, login to view] server SQL Server configured for thread mode processing.
2013-11-15 15:44:[url removed, login to view] server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2013-11-15 15:44:[url removed, login to view] server Attempting to initialize Distributed Transaction Coordinator.
2013-11-15 15:44:[url removed, login to view] spid3 Starting up database 'master'.
2013-11-15 15:44:[url removed, login to view] spid3 Error: 9003, Severity: 20, State: 1.
2013-11-15 15:44:[url removed, login to view] spid3 Cannot recover the master database. Exiting.

We would like if possible to restore the instance to a working state with most of the data in the databases intact. There might be a backup but it was created after the problem occurred so we don't know if it's valid and working. Feel free to send messages if you need more info. Thanks in advance

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online