asked on

SQL

I am having problem running SQL all I am gettign is saying connection could not stablish to local host " I have atached the log .
It's running on to my local machine and I have a critical data which I can' afford to loose.
it was running OK untill I shut my machine off while it was booting.(Terible mistake)

Thanks

wjahi

2009-02-17 09:48:43.46 server    Microsoft SQL Server  2000 - 8.00.760 (Intel X86) 
	Dec 17 2002 14:22:05 
	Copyright (c) 1988-2003 Microsoft Corporation
	Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3)
 
2009-02-17 09:48:43.46 server    Copyright (C) 1988-2002 Microsoft Corporation.
2009-02-17 09:48:43.46 server    All rights reserved.
2009-02-17 09:48:43.46 server    Server Process ID is 1872.
2009-02-17 09:48:43.46 server    Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2009-02-17 09:48:43.49 server    SQL Server is starting at priority class 'normal'(1 CPU detected).
2009-02-17 09:48:43.60 server    SQL Server configured for thread mode processing.
2009-02-17 09:48:43.62 server    Using dynamic lock allocation. [2500] Lock Blocks, [5000] Lock Owner Blocks.
2009-02-17 09:48:43.64 server    Attempting to initialize Distributed Transaction Coordinator.
2009-02-17 09:48:43.73 server    Failed to obtain TransactionDispenserInterface: Result Code = 0x8004d01b
2009-02-17 09:48:43.74 spid3     Starting up database 'master'.
2009-02-17 09:48:43.84 spid3     Error: 9003, Severity: 20, State: 1.
2009-02-17 09:48:43.84 spid3     Cannot recover the master database. Exiting.

Open in new window

BrandonGalderisi

It would seem that your master database is missing or corrupt. Look in your file system for master.mdf and master.ldf.

Default location:

c:\Program Files\Microsoft SQL Server\MSSQL\DATA\master.mdf

wajhiuddin

ASKER

Yes master.mdf is there but master.ldf is not
what should I do next?

Thanks

wajhi

BrandonGalderisi

Do you have a backup of master?

wajhiuddin

ASKER

No I don't

ASKER CERTIFIED SOLUTION

BrandonGalderisi

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

wajhiuddin

ASKER

I am trying to run rebuildm to . I stop SQL and
even have deleted sqlmangr.exe out of Task Manager "Processes". I have
everything closed on the machine. SQL is definitely down - No services show
in "Services". However, when I run rebuildm - after I enter where the data
files are and the new collation and press Rebuild it returns an error. First
One "Cannot copy master: It is being used by another person or program.
Close any programs that might be using the file and try again" When I press
OK I get "Rebuild Master failed with error 266: The copy function cannot be
used. The error occurred due to a file copy failure"

wajhiuddin

ASKER

I reinstalled SQL which resolved the issue all data was fortunately there
Thanks all

BrandonGalderisi

I object because that's what I said was the easiest solution in http:#a23663215

wajhiuddin

ASKER

I agree but i didn't want to risk my data at the start but I decided to do once I had no choice

I appreciate your suggestion

Tahnsk

Wajhi

BrandonGalderisi

Then http:#a23663215 is the correct answer.