May 14, 2011 at 10:06 am
Dear all,
2-3 times per month I get the follownig error to Server event viewer:
"The log for database 'Itemtracker_Xenia' is not available. Check the event log for related error messages. Resolve any errors and restart the database."
The event log says nothing helpful. When I restrt SQL server service everything is up and running. Haw anybody any good ideas from where to start investigate the problem ?
May 14, 2011 at 10:58 am
Please check the event logs for any errors related to disks.
Pradeep Adiga
Blog: sqldbadiaries.com
Twitter: @pradeepadiga
May 14, 2011 at 11:24 am
Please check out the following article:
http://support.microsoft.com/kb/937343
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
May 14, 2011 at 11:27 am
Also talk to your SAN guys - or your SAN vendor, if the LUN where the log file is located has been presented from a SAN and is not direct attached storage.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply