• To be a mirror or principal partner, the endpoint's role has to be either "partner" or "all". Both can be "partner, both can be "all" or one can be "partner" while the other is "all". That's all fine.

    Grantor is informational only and has no net effect on the mirroring session. It does not matter who granted it.


    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]