• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1405
  • Last Modified:

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

0
wajhiuddin
Asked:
wajhiuddin
  • 5
  • 5
1 Solution
 
BrandonGalderisiCommented:
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
0
 
wajhiuddinAuthor Commented:
Yes master.mdf is there but master.ldf is not
what should I do next?

Thanks

wajhi
0
 
BrandonGalderisiCommented:
Do you have a backup of master?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
wajhiuddinAuthor Commented:
No I don't
0
 
BrandonGalderisiCommented:
The easiest/quickest way would be to rebuild master by reinstalling.

http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_20077067.html

But there are other, more involved processes, that will allow you to start in emergency mode and rebuild the log file.

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=114812
0
 
wajhiuddinAuthor Commented:
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"
0
 
wajhiuddinAuthor Commented:
I reinstalled SQL which resolved the  issue all data was fortunately there
Thanks all
0
 
BrandonGalderisiCommented:
I object because that's what I said was the easiest solution in http:#a23663215
0
 
wajhiuddinAuthor Commented:
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

0
 
BrandonGalderisiCommented:
Then http:#a23663215 is the correct answer.
0

Featured Post

Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

  • 5
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now