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.
| 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 AdvanceSRK39 |
|
|
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. |
 |
|
|
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 driveJack Vamvas--------------------http://www.sqlserver-dba.com |
|
|
|
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 AdvanceSRK39 |
|
|
|
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 KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
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 |
|
|
|
|
|
|
Temdb log