Help tempdb GONE - sql 2005
Posted on 2006-10-20
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:
Alter database tempdb modify file (name = tempdev, filename = 'E:\Sqldata\tempdb.mdf')
Alter database tempdb modify file (name = templog, filename = 'E:\Sqldata\templog.ldf')
and i got the correct message - but again when i stopped and started sql service - tempdb was still not there.