BACKUP LOG Blocking CHECKPOINT

• JohnnyDBA

  SSCertifiable

  Points: 6355

  More actions

  August 27, 2009 at 12:53 pm

  #137693

  On certain client servers we are seeing that our backup process for the transaction log appears to be blocking the CHECKPOINT process. Does anyone know why this might happen? It only seems to happen for a half a second or so. I don't think this is causing any issues but I'd like to know "under the hood" why this is happening and what to know in order to avoid any potential issues.

  Thanks,

  John

• Lynn Pettis

  SSC Guru

  Points: 442467

  More actions

  August 27, 2009 at 1:16 pm

  #1045815

  Blocking the checkpoint seems logical to me. Ensures a consistant backup of the transaction log.