Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Log for database tempdb is not available Expand / Collapse
Posted Thursday, August 21, 2014 11:15 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Thursday, October 13, 2016 7:33 AM
Points: 250, Visits: 462
Suddenly, SQL server 2000 becomes unresponsive and throws the following error:

Error: 9001, Severity: 21, State: 1
The log for database 'tempdb' is not available.

After the sql restart, things are back on track. pls help
Post #1605934
Posted Thursday, September 4, 2014 6:59 AM


Group: General Forum Members
Last Login: Tuesday, February 9, 2016 8:48 AM
Points: 149, Visits: 440
you should have checked for previous logs as well. see if you find anything in eventviewer.
it can be tempdb full issue but not certain. also what is the tempdb recovery mode and autogrowth n all.
Post #1610484
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse