Home Forums SQL Server 2005 Administering SQL Server 2005 - Database Mirroring (Change of Recovery Model) RE: SQL Server 2005 - Database Mirroring (Change of Recovery Model)

  • Steve Jones - SSC Editor (12/6/2010)


    Mirroring doesn't affect the log, with the exception that the log is needed to send the data to the mirror database.

    unless mirroring gets suspended, then log grows because log records can't be discarded.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass