Em Andamento

Recover SQL instance from SQL Server 2000 - Corrupt Master Database

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

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

Ver mais: starting database master, service courier, service coordinator, program coordinator, intel corporation, id pack, database coordinator, 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, lock file program, database connect error, backup mssql, transaction processing program

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

ID do Projeto: #5147882

Premiar a:

elboukharimu

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)
4.6

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

customizedata

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)
5.2
marasinghe82

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)
4.7
permourikis

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)
4.7
Prateekagra

i have sound knowledge of sql administration and i have 7 year of experience on this.you 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)
4.0
Lee2133

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)
4.0
yubor

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)
3.6
sensefreak

hi! I can help you with 2000 server and sql. MCSE on 2000, drop a line here or contact me via skype: kosta.volkoboy if you are interested. Cheers K

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

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)
3.5
bentaylor

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)
3.3
ahetel

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)
2.9
manjusha02

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)
2.7
zeoinf

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)
2.7
arkac

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)
1.5
onnlight

A proposal has not yet been provided

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

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)
0.0
swifttekno

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)
0.0
creatorip

A proposal has not yet been provided

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

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)
0.0
Singh160

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)
0.0
reddyjgl

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)
0.0