The log for the database tempdb is missed and db shutdown?Is it because of msdb in suspect mode?

Question

Hi,

The log for the database tempdb is missed and db shutdown?Is it because of msdb in suspect mode?

Thanks,

ron

Answer 1

Could you please describe the issue in little more detail?

---

Kind regards| Harsh Chawla | Personal Blog:- SQL-blogs
|Team Blog:- Team Blog

Answer 2

Recently we got disk corrupted issue after resolveong that issue when i open the sql db i am getting the

error msg 'The log for databse tempdb i snot avilable.check the event log for related error messages.Resolve any errors and restart the databse'

Thanks,

Ron.

Answer 3

tempdb files will be re-generated when you re-start SQL Server service. Might be SQL Server service account lost the permissions on disk where tempdb files generating.

---

http://uk.linkedin.com/in/ramjaddu

Answer 4

beside missing permissions it may be possible the path stored in SQL Server does no longer exists as the replaced drive does have a different drive letter or the path to the old tempdb log does no longer exists.

Therefore check that the path used previously for tempdb logfile does exists and the SQL Server Service Account does have permission to access this folder.

Answer 5

Hi Ronsql,

>>'The log for databse tempdb i snot avilable.check the event log for related error messages.Resolve any errors and restart the databse'

Could you try to take the database offline and then bring it back online again, which would help you to solve your issue. And also you can increase tempdb size manually and the size is the half size of the biggest database size in this instance.

Meanwhile please read this KB FIX: SQL Server 2005 stops and then restarts unexpectedly, and errors occur in the tempdb database 

For further troubleshooting, please post the error log.

---

Regards, Amber zhang