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.  Lock Blocks,  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.
20 freelancers are bidding on average €108 for this job
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.
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 λύθηκε το πρόβλημα?
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
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.
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
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
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