Help could not create tempdb -
07-14-2006
, 08:33 AM
Hi,
need help urgently in resolving the follow issue for ms sql 2005.
Unable to startup the databases. Following is a summary of the error in the log file
Clearing tempdb database
Error:913, severity :16 l state 8.
could not find database 2. Database may not be active or may be in transition. Reissue the query once the database is available. ....
could not create tempdb. you may not have enough disk space available. Free additional disk space by deleting other files on the tempdb drive
This happen after i accidentally did a sp_detach_db tempdb
I had tried to perform the following as mentioned in one of the thread but it don't help.
Start the SQL with the -T3608 and -f flags, and do the work in Query Analyzer.
1) Start SQL and QA as above
2) Run sp_attach tempdb (see BOL for full syntax).
==> it mentioned tempdb already exist. But when I query master..sysdatabases, dbid 2 is not there.
3) Run UPDATE master..sysdatabases set dbid = 2 where name = 'tempdb'
It throw update error
4) Remove the -T3608 and -f flags and restart SQL.
Please help |