July 30, 2004 at 11:33 am
My SQL-server failes to startup.
When starting up with 'sqlservr -c -f'; I get the follwing messages :
2004-07-30 19:22:42.42 server SQL Server is ready for client connections
2004-07-30 19:22:42.54 spid5 Clearing tempdb database.
2004-07-30 19:22:42.94 spid5 Could not find database ID 2. Database may not
be activated yet or may be in transition.
2004-07-30 19:22:42.96 spid5 WARNING: problem activating all tempdb files.
See previous errors. Restart server with -f to correct the situation.
How to resolve this problem ?
July 30, 2004 at 12:56 pm
IMHO it is something wrong with data and log files of tempDB. You can try to put the files tempDB.mdf and templog.log into this server's DATA folder. You can copy them from any other instance of sql server.
July 30, 2004 at 1:21 pm
It depends on what database id 2 is. It might be the MODEL database.
When you restart SQL Server, TEMPDB is rebuilt from scratch. How are new databases built? From the MODEL database. I believe rebuilding TEMPDB depends on the MODEL database. Check to see if those files exist.
-SQLBill
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply