• If the principal fails and you have unsent log then it doesn't matter whether you go for automatic or manual failover, failing over manually won't magically make the unsent log records materialise on the mirror. Depending on the type of failure, you might be able to salvage the data after the principal comes back online. Of course, if it was a drive failure and the DB files are gone, then not so much.

    Make sure the line can handle the expected load, test, test, test, make sure that the unsent log never gets above the allowable data loss for your system.

    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