DB log file missing

• ionas

  Mr or Mrs. 500

  Points: 551

  More actions

  May 14, 2011 at 10:06 am

  #239534

  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 ?

• Adiga

  One Orange Chip

  Points: 27284

  More actions

  May 14, 2011 at 10:58 am

  #1324635

  Please check the event logs for any errors related to disks.

  Pradeep Adiga
  Blog: sqldbadiaries.com
  Twitter: @pradeepadiga

• Welsh Corgi

  SSC Guru

  Points: 116520

  More actions

  May 14, 2011 at 11:24 am

  #1324637

  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/

• Jeffrey Williams

  SSC Guru

  Points: 90345

  More actions

  May 14, 2011 at 11:27 am

  #1324639

  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