SQL Server Performance

Database Mirroring within One Server

Discussion in 'SQL Server 2005 Database Mirroring' started by YoshiHan, Oct 29, 2006.

  1. YoshiHan New Member

    Is it possible to have multiple mirror endpoints for database mirroring within one server ?
    YoshiHan, Oct 29, 2006
    #2

  2. bradmcgehee New Member

    I haven't tried mirroring on the same SQL Server instance, but what I have been doing, for practice, is to install two instances of SQL Server 2005 on my server, and test mirroring between the instances.

    -----------------------------
    Brad M. McGehee, SQL Server MVP
    bradmcgehee, Oct 30, 2006
    #2

  3. LeClair New Member

    According to BOL, no: "All mirroring connections on a server instance use a single database mirroring endpoint. "

    Just curious, why?

    -Greg
    LeClair, Nov 1, 2006
    #2

Share This Page