Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cmptom
Starting Member
4 Posts |
 Posted - 2007-11-13 : 17:32:23
|
| Hi,I am new to this forum and new to SQL, hope someone can help me. TIAI have SQL 2000 running on the windows 2000 server. The program reside on the E drive and the data reside on the D drive, my system files drive C got corrupted and gave me the blue screen of death, so I had to reload it from back up, but in doing so, my SQL "Local" default instance fail to load after I got the server back up and running. My other instances are running fine except for the Local. Is their a way to bring that back? or do I have to reload SQL default instance ?Thanks |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-13 : 22:13:38
|
| Did you see service of that instance? Can you start it manually? Did you see any error in windows app event log? |
 |
|
|
cmptom
Starting Member
4 Posts |
Posted - 2007-11-14 : 12:25:47
|
| Yes, I tried to start it manually but it fails every time and the sys log is showing an eventid 7000, 7001app log eventid is 17055 with the description:initconfig: error 2(The system can not find the file specified) opening "C:\program files\Microsoft SQL Server\MSSQL\data\master.mdf' for configuration information |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-14 : 22:26:39
|
| Did you find master db file there? |
|
|
|
cmptom
Starting Member
4 Posts |
Posted - 2007-11-15 : 16:36:44
|
| Yes, I found the master db file, northwind, pub and so on |
|
|
|
cmptom
Starting Member
4 Posts |
Posted - 2007-11-15 : 19:09:21
|
| Ok we got it back up and running,what we did was install a new instance of the local onto another machine and then copy those fiels over to my existing sql server, run sql recovery and recover those new fake master and SQL is now running again. |
|
|
|
|
|
|
|
|
SQL default instance fail to start