troubleshooting Question

SQL server 2005 tempdB not found

Avatar of marrowyung
marrowyung asked on
Microsoft SQL Server 2005Microsoft SQL Server 2008
26 Comments2 Solutions1830 ViewsLast Modified:
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 ?
IT Director

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 26 Comments.
Start Free Trial
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.

-Mike Kapnisakis, Warner Bros