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)

  • Please read through this - Managing Transaction Logs[/url]

    To keep the log small you need frequent log backups. Don't shrink, it's just going to grow again. The size of the log file has no impact on your backups. What has impact on your backups is the size of the active portion of the log around the time of backup, but that's the same in full and simple recovery.

    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