troubleshooting Question
SQL server 2005 tempdB not found
Dear all,
Today get a quite special event from the SQL server 2005 with SP2 that:
"The log for database 'tempdb' is not available. Check the event log for related error messages. Resolve any errors and restart the database."
the tempdb mdf and ldf file is here but the event log has some red event about that.
What I did is try to stop it from SQL configuration manager but the SQL server service hangs, then I kill it using taskkill /pid: <SQL service pid>, then start it again and everything works well again.
I restart it again and everything still normal.,
any experinece from you all on this ?
Today get a quite special event from the SQL server 2005 with SP2 that:
"The log for database 'tempdb' is not available. Check the event log for related error messages. Resolve any errors and restart the database."
the tempdb mdf and ldf file is here but the event log has some red event about that.
What I did is try to stop it from SQL configuration manager but the SQL server service hangs, then I kill it using taskkill /pid: <SQL service pid>, then start it again and everything works well again.
I restart it again and everything still normal.,
any experinece from you all on this ?
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 26 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.