Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Temdb log

Author  Topic 

ksr39
Posting Yak Master

193 Posts

Posted - 2015-01-06 : 09:34:45
Hi Experts,
I have an issue with Tempdb, I see an error message “The log for database 'tempdb' is not available. Check the event log for related error messages. Resolve any errors and restart the database.” The application are down due to this and I am seeing only this message in the windows logs and SQL logs.
This error I got yesterday as well, I have restarted the services and at that time it was doing well, but in the morning I see the same error and the application team saying that they are facing the same issue. I see the files in their respective folders.
Its SQL Server 2008R2 with 4 instances in it, It’s a standalone box.
Please let me know whether it’s a windows or SQL.


Thank You All In Advance
SRK39

jeffw8713
Aged Yak Warrior

819 Posts

Posted - 2015-01-06 : 14:02:57
I would check to see if you have lost connection to the drive hosting the tempdb log file. If that drive becomes disconnected for any length of time - SQL Server will fail and won't check again.
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2015-01-07 : 01:49:08
Do a select * from sys.sysfiles on tempdb. Identify the location of the log file. Is it there?
If you find you're losing conection, then either fix the prolem or more the log file to another drive

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

ksr39
Posting Yak Master

193 Posts

Posted - 2015-01-12 : 13:31:37
Thank you for the reply, sorry for the late response. I checked and see that the drive is available and the files i can see them.

Thank You All In Advance
SRK39
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2015-01-12 : 14:19:52
It sounds like SQL Server is momentarily losing the tempdb drive. Even if it's only for a second you're going to have a problem. Check the event log for hardware and disk issues.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2015-01-13 : 01:35:52
If you're losing the drive supporting the tempbds - a common windows server is something like 'could not find the IO device'

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -