locked
Issue in database Mirroring endpoints RRS feed

  • Question

  • Hi..

    I am using sql server 2008 with sp3. I have two instance of sql server on a server i. e. one is default instance and another is named instance and both instances are mirror servers in database mirroring.

    Normally in a single instance of sql server , we use only one endpoint for database mirroring.

    Can we use same endpoint like 5023 for database mirroring(on mirror server) in both instances of sql server in a window server ?.

    Pls suggest me.......


    Mark As Answer If My Reply Is Helpful
    Thanks
    Neeraj Bhandari (MCTS - Sql Server 2008)

    Thursday, February 28, 2013 4:58 AM

All replies

  • Two instances in a single server are involved in mirroring. You cant use same endpoint then.

    I would like to know what is the purpose of running principal and mirror on same server. We are defeating the Mirroring purpose in this case.


    Srinivasan

    Thursday, February 28, 2013 9:52 AM
  • No it can't be used.

    see similar one ->http://social.msdn.microsoft.com/Forums/en-US/sqldatabasemirroring/thread/0745f56c-e4df-4d92-9ee2-9f3dcba2b5f1


    Thanks, Rama Udaya.K (http://rama38udaya.wordpress.com) ---------------------------------------- Please remember to mark the replies as answers if they help and UN-mark them if they provide no help,Vote if they gives you information.

    Thursday, February 28, 2013 5:54 PM
  • Hi..

    Thanks for reply..

    Principal and mirror is not running on same server. This server is being use only for mirror for other two principal server.


    Mark As Answer If My Reply Is Helpful
    Thanks
    Neeraj Bhandari (MCTS - Sql Server 2008)

    Friday, March 1, 2013 4:18 AM
  • no as communication is done with the port number you cannot have same port for principle and mirroring databases

    Ramesh Babu Vavilla MCTS,MSBI

    Friday, March 1, 2013 5:11 AM