Em Andamento

Recover SQL instance from SQL Server 2000 - Corrupt Master Database


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:39.52 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:39.52 server Copyright (C) 1988-2000 Microsoft Corporation.

2013-11-15 15:44:39.52 server All rights reserved.

2013-11-15 15:44:39.52 server Server Process ID is 1276.

2013-11-15 15:44:39.52 server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL$COURIER\log\ERRORLOG'.

2013-11-15 15:44:39.54 server SQL Server is starting at priority class 'normal'(1 CPU detected).

2013-11-15 15:44:39.58 server SQL Server configured for thread mode processing.

2013-11-15 15:44:39.58 server Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.

2013-11-15 15:44:39.60 server Attempting to initialize Distributed Transaction Coordinator.

2013-11-15 15:44:41.70 spid3 Starting up database 'master'.

2013-11-15 15:44:41.74 spid3 Error: 9003, Severity: 20, State: 1.

2013-11-15 15:44:41.74 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

Just adding some more info based on your comments and suggestions. I wanted to inform you that there is no SQL Server 2000 CD available and probably no documentation available either since this is an over 10 years old system. Since the instance is not working and the client program can't connect to that instance there is no way to know if the databases in that instance are still intact that's why we need to recover the instance with it's databases.

I will evaluate your proposals during the next 2 days and in the meantime replicate the server environment so I can give access and allow you to get a better look at the issue then contact those that I feel are the most experienced. Since the original server is running also another sql server instance which is very important to not be disrupted, I'm positive that if you can work on this problem in a replicated environment and then we can apply your patch in the real server as well.

Also thank you very much for your fast responses.

Habilidades: Administração de Bancos de Dados, SQL, Servidor Windows

Ver mais: error 9003 sql server 2000, starting database master, the courier service, service-master, service courier, service coordinator, program coordinator, intel corporation, id pack, database coordinator, c. t. corporation, Sql Database administration, recover database, MICROSOFT SQL SERVER, dynamic connect, database microsoft sql, data recover, build sql, build database sql, sql created, windows service start process, microsoft dynamic 2013, file corrupted, connect database error, SQL Server administration

Acerca do Empregador:
( 4 comentários ) Nea Efkarpia, Greece

ID do Projeto: #5147882

Premiar a:


Hi, I'm very interested helping you resolving your database problem, I can recover your Master database because I did it before. I have years of experience in SQL and database administration, modeling, and manipulating Mais

€105 EUR em 3 dias
(16 Avaliações)

20 freelancers estão ofertando em média €108 para este trabalho


Can you provide me with the system access where this database resides. Maybe we could find the lad and mdf files there and can generate the db from there.

€111 EUR in 7 dias
(43 Comentários)

Dear Sir can you share the server using TV session I can connect now Please assign this task for me I can assure 100% completion. I'm very much familiar with MS SQL Server ( SSIS SSAS SSRS) and also during la Mais

€83 EUR em 1 dia
(29 Comentários)

Lets see what the status of the server is and how data will be restored. PS do you think that a newer SQL version of SQL server express is an option? Στη διάθεσή σου για περισσότερα. Update λύθηκε το πρόβλημα?

€100 EUR in 3 dias
(25 Comentários)

i have sound knowledge of sql administration and i have 7 year of experience on [url removed, login to view] can see my review also on the sql i have very experience over this tell me when we can talk further to do this

€111 EUR in 2 dias
(5 Comentários)

Hi There Senior Engineer here, I would like to complete this project for you. let me knw when you're available thanks.

€150 EUR in 3 dias
(8 Comentários)

Hi. I am certified MS SQL Server expert (MCSE, MCITP) and have worked with mssql since version 6.5. Would be glad to help you with this project. Regards, Yuri.

€133 EUR in 7 dias
(16 Comentários)

hi! I can help you with 2000 server and sql. MCSE on 2000, drop a line here or contact me via skype: [url removed, login to view] if you are interested. Cheers K

€77 EUR em 1 dia
(8 Comentários)

Hi, We are fast growing hosting company in India. We have expertise in Linux and Windows server setup with management. We work in different technologies like VMware, Hyper V, Microsoft exchange etc. And work wit Mais

€100 EUR em 1 dia
(4 Comentários)

Hi, I have recover SQL instances like this in the past! Do you know if the application DB's are still intact? The recovery of these DB's will probably mean rebuilding the master DB. I can be contacted a var Mais

€111 EUR in 3 dias
(4 Comentários)

Hi, Do you have SQL Server 2000 CD? I might need it. You need to rebuild the master database. I was facing worse situations that this. Best regards, Andrei Hetel

€111 EUR em 1 dia
(7 Comentários)

I have more than 5 years of experience in SQL Server Administration, I can recover this DB with in a day.

€111 EUR in 3 dias
(2 Comentários)

I experienced similar problems in the past. I also work with sql 2000 in big company that don't like upgrades.. Probably, if master db is corrupted, the best way is to rebuild the istance. I propose to test if d Mais

€88 EUR in 3 dias
(3 Comentários)

Looks like your master database is corrupted . This is not a disaster... It can be solved..... I would need your sql server cd or iso or the installer directory .... Apart from this since your payment method is v Mais

€66 EUR in 0 dias
(2 Comentários)

A proposal has not yet been provided

€111 EUR in 3 dias
(0 Comentários)

I'm a Microsoft Certified Senior Systems Engineer with more than 20 years of experience. I can do the job for you.

€55 EUR in 3 dias
(0 Comentários)

Hello I need to know few Question: How many user Databases are there and is there is any Backup of System Databases

€111 EUR in 3 dias
(0 Comentários)

A proposal has not yet been provided

€111 EUR in 3 dias
(0 Comentários)

I have extensive experience that meets the qualifications, and would be happy to complete this work for you. We can speak via telephone, skype, yahoo im, aim, msn messenger, or irc chat. Thank you, Sean Brady

€111 EUR in 3 dias
(0 Comentários)

I have 10+ years of experience working as Database Administrator/ Architect experiencing in Project Designing, Management& Implementation. Various solutions will be available with different requirements. so will choose Mais

€150 EUR in 3 dias
(0 Comentários)

6 years of experience in IT industry having strong skills in SQL Server Administration and Production support. Experience in Installation, configuration, Maintenance and Administration of MS SQL Server 2000/2005/2008/ Mais

€111 EUR in 3 dias
(0 Comentários)