June 14, 2002 at 5:04 am
Came in this morning and Enterprise Manager is not showing any databases.
Tried to access Current Activity, got
Error 9001 : The log for database 'tempdb' is not available.
All other databases look fine.
Tried a DBCC on the tempdb and get
Server: Msg 8999, Level 16, State 1, Line 0
Database tempdb allocation errors prevent further CHECKDB processing.
Server: Msg 8905, Level 16, State 1, Line 0
Extent (1:96) in database ID 2 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 0
Extent (1:104) in database ID 2 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 0
Extent (1:120) in database ID 2 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
Server: Msg 8905, Level 16, State 1, Line 0
Extent (1:128) in database ID 2 is marked allocated in the GAM, but no SGAM or IAM has allocated it.
These messages are a known bug in 2000 and Microsoft recommend sp2 but i'm running 7.0 on an NT4 cluster.
Has anyone got any ideas on this ?
June 14, 2002 at 6:20 am
I have had this before and this should correct.
Stop SQL Server
Find tempdb.mdf and templog.ldf (usually in the data folder unless you moved).
Delete both (SQL automatically rebuilds these every restart but they hang when this problem occurrs most times).
If the files are locked and it won't let you delete open Services and set SQL to disabled, then reboot your server.
Try delete again.
If still not go use cmd prompt and do a delete on the files (never had to go this far).
Set SQL to automatically again if had to disable.
Reboot server.
Try again should be fine when rebuild is done.
Note: Never found an issue and never occurred again (may have been a file system problem).
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
June 14, 2002 at 6:33 am
Worked perfectly, thanks for your help
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply