Check Transaction Log Before backup

• Marcelo Bentolila

  Grasshopper

  Points: 23

  More actions

  October 18, 2004 at 2:46 pm

  #86768

  Hello,

  the integrity of the data bases is controlled with the DBCC Checkdb command. Exists some form to control the transaction log integrity?

  Thanks

• Wesley Brown

  SSChampion

  Points: 12045

  More actions

  October 18, 2004 at 4:17 pm

  #527096

  dbcc checkdb checks every aspect of the database in a quick manor, this includes the log

  Wes

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738871

  More actions

  October 19, 2004 at 12:01 pm

  #527223

  Since they log OR the data are required to restore, I don't worry about this. dbcc will check this.