Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Log for database tempdb is not available Expand / Collapse
Author
Message
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: Saturday, October 18, 2014 9:03 PM
Points: 202, Visits: 358
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
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Today @ 4:38 AM
Points: 124, Visits: 197
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