Database mirroring "log granularity"

• FelixG

  SSCrazy

  Points: 2550

  More actions

  June 23, 2010 at 9:24 am

  #145737

  In a database mirroring scenario does the principal server send the log records to the mirror at log record level or transaction level?

  In other words: a transaction can have more than one record in the log...

  In this case: does the principal server wait for the commit transaction to harden all the records and send them to the mirror server, or does the principal write the records to its log and send the records one by one as soon as they are recorded to the transaction log?

• ImYourDBA

  SSCertifiable

  Points: 5654

  More actions

  June 23, 2010 at 9:49 am

  #1184045

  In synchronous mode every transaction is hardened to the mirror before being committed at the principal.

  In asynchronous mode (Enterprise only), the transactions are committed at the principal and then sent to the mirror when possible.

  Owner & Principal SQL Server Consultant
  Im Your DBA, Inc.
  https://www.imyourdba.com/