detached tempdb

[Bell1991]

So, i made a huge mistake... I detached the tempdb - and now sql is not working.

I am using sql server 2005 - and i can't modify the systables.

I have also tried rebuilding the master database but i get an error saying: sql_engine not in feature class.

Any suggestions?

thanks in advance

 

[mrdenny]

How prey tell did you detach the tempdb?

What is reported in the errorlog when you try to start the service?

Try starting SQL from the command line in single user mode.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Bell1991]

well i was finally able to restore the master.. wasn't as easy as i remember - but i guess i have only restored the master when tempdb was there and no other problems!

I wish the sp_detach_db did not work for trmpdb - but it does!