Help tempdb GONE - sql 2005

I was attempting to move the tempdb to a different drive using sql 2005.

Here are the steps i took:
Added: -T3608 to the startup parameters
stopped and started sql service

detached the tempdb

attempted to reattach and i got the error 'tempdb already exist'

So, i tired to detach again and it said 'tempdb' does not exist

I have tried using the alters:
use master
go
Alter database tempdb modify file (name = tempdev, filename = 'E:\Sqldata\tempdb.mdf')
go
Alter database tempdb modify file (name = templog, filename = 'E:\Sqldata\templog.ldf')
go

and i got the correct message - but again when i stopped and started sql service - tempdb was still not there.

Please help



DJMoonLightAsked:
Who is Participating?
 
NightmanConnect With a Mentor CTOCommented:
glad you got it sorted out - at least now you knwo for next time that you don't need to detach it, simply Alter Database and restart SQL
0
 
DJMoonLightAuthor Commented:
well, i have tried just about everything..

I just tried to rebuild my master and i get the following error:

The installer has encountered an unexpected error.  The error code is 2711.  The specified Feature name (‘sql_engine’) not found in Feature table

any suggestions?
0
 
NightmanCTOCommented:
did you remove the -T3608 from the startup parameters?

SQL Server does not recover any database except the master database with this flag.
0
 
DJMoonLightAuthor Commented:
yes - when i remove the trace flag - sql will not start..

I was finally able to restore my master and got everything back..  
0
 
Eugene ZConnect With a Mentor Commented:
<and i got the correct message - but again when i stopped and started sql service - tempdb was still not there.
if you started the sql server than you just needed to refresh view of your windows explorer...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.