Transaction log file missing

• y.koteswarrao-652921

  SSCrazy

  Points: 2010

  More actions

  July 21, 2010 at 2:57 am

  #146302

  hi,

  if the transaction log is missing and the database was cleanly shut down, SQL will recreate it. If the the transaction log is missing and the database was not cleanly shut down, the database goes into the RECOVERY_PENDING state.

  Is it correct answer?

  Koteswar Rao

• Knowledge Hunter

  SSCrazy

  Points: 2287

  More actions

  May 24, 2011 at 6:26 am

  #1328993

  If transaction logs are missing you will have to take a differential backup to maintain the continuity.

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  May 24, 2011 at 6:31 am

  #1328997

  http://sqlinthewild.co.za/index.php/2009/06/09/deleting-the-transaction-log/

• saileeth1

  Valued Member

  Points: 72

  More actions

  May 26, 2015 at 2:59 am

  #1800504

  what do you mean by database cleanly shut down?