• About the only use is as part of a rolling upgrade, so install a second SQL instance (same version), configure mirroring, make sure everything works and the app redirects properly, upgrade the mirror (now running higher version mirror than principal), fail the mirroring over, upgrade the principal, fail the mirroring back (or, if you're migrating hardware as well, leave the 'mirror' as the new principal).

    Version upgrade with minimal downtime (one or two failovers).

    In a rolling upgrade though you wouldn't install the mirroring with mismatched versions, it would just be that way for a brief time during the upgrade.

    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