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
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
did you remove the -T3608 from the startup parameters?
SQL Server does not recover any database except the master database with this flag.
SQL Server does not recover any database except the master database with this flag.
ASKER
yes - when i remove the trace flag - sql will not start..
I was finally able to restore my master and got everything back..
I was finally able to restore my master and got everything back..
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
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?