locked
Mirroring with multiple instances? RRS feed

  • Question

  • Have a server with 4 SQL 2008 instances loaded on it.  One of these instances is a witness for another set of servers within the organization and has an endpoint already created for database mirroring.

    The question here relates to the endpoint.  I want to mirror a DB on an instance other than the one (Witness instance) that does already have the endpoint created.  Do I need to create DB mirroring endpoints for every instance that I want to mirror and give it a different port than the original 5022 that the first one is using?

    Thanks!

    Tuesday, November 2, 2010 1:15 PM

Answers

  • Maybe - I misunderstand your question. I cannot mirror a single database to multiple mirrors.

    I do have the ability to have different instances mirror on different ports.


    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
    • Marked as answer by Tom Li - MSFT Wednesday, November 10, 2010 3:15 AM
    Tuesday, November 2, 2010 1:22 PM
    Answerer

All replies

  • No, this can't be done. You can only mirror to one server/mirror.

    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
    • Marked as answer by Tom Li - MSFT Wednesday, November 10, 2010 3:14 AM
    • Unmarked as answer by Tom Li - MSFT Wednesday, November 10, 2010 3:15 AM
    Tuesday, November 2, 2010 1:21 PM
    Answerer
  • Maybe - I misunderstand your question. I cannot mirror a single database to multiple mirrors.

    I do have the ability to have different instances mirror on different ports.


    looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941
    • Marked as answer by Tom Li - MSFT Wednesday, November 10, 2010 3:15 AM
    Tuesday, November 2, 2010 1:22 PM
    Answerer