Link to home
Start Free TrialLog in
Avatar of DJMoonLight
DJMoonLight

asked on

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



Avatar of DJMoonLight
DJMoonLight

ASKER

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?
did you remove the -T3608 from the startup parameters?

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

I was finally able to restore my master and got everything back..  
ASKER CERTIFIED SOLUTION
Avatar of Nightman
Nightman
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Avatar of EugeneZ
EugeneZ
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial