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 ?
  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
  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

Share This Page