I have to move all databases to new drive. I moved the application databases without difficulty. I now have to move the system databases. I found an article telling me to run sp_detach_db on the model and msdb. I mistakenly ran sp_detach_db on the tempdb also. It told me the tempdb already exists. When I start the MSSQL 2005 server service, I receive the following error ...
"Clearing tempdb database.
Error: 913, Severity: 16, State: 8.
Could not find database ID 2. Database may not be activated yet or may be in transition. Reissue the query once the database is available. If you do not think this error is due to a database that is transitioning its state and this error continues to occur, contact your primary support provider."
I can start the SQL server with the switches -c -m -T3608, but I am not able to do anything about this issue at that point.
I could really use some help with this problem?