• Yes, but it's an exceedingly bad idea and it's only supported as part of a rolling upgrade process.

    The mirroring will work, however if that ever fails over then the new principal is 2008 R2 and the mirroring will go suspended and you won't be able to resume without upgrading the 2005 server.

    Essentially it's a failover implementation that you can never ever fail over, kinda pointless.

    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