• My general rule of thumb is that you should back up the log AT LEAST every half hour. If the database is busy, then do it more frequently. The busier the database is, the more frequently you should back it up. This is the corner stone of log file maintenance.

    When you shrank the log file on the principal, did it shrink on the mirror as well? If not, what build of SQL Server are you on?


    My blog: SQL Soldier[/url]
    SQL Server Best Practices:
    SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]