locked
Database mirroring RRS feed

  • Question

  • Hi all,

    what is the default endpoint in the database mirroring....?


    • Edited by SLNSH Sunday, March 31, 2013 3:38 PM
    Saturday, March 30, 2013 12:22 PM

Answers

  • Hi SLNSH,

    All Database Mirroring traffic is transmitted through a TCP endpoint with a payload of DATABASE_MIRRORING. You can create only one Database Mirroring endpoint per SQL Server instance.

    By default, the Database Mirroring endpoint is defined on port 5022. The database mirroring endpoint listens on a unique TCP port number. Combine TCP endpoint and a payload, I think it is the default endpoint.

    You can configure multiple SQL Server instances on a single server, and each instance can have a single Database Mirroring endpoint. However, you must set the port number for the Database Mirroring endpoint on each instance on the same server to a different port number.

    The Database Mirroring Endpoint (SQL Server): http://msdn.microsoft.com/en-us/library/ms179511.aspx.

    Thanks.  


    Maggie Luo
    TechNet Community Support

    • Proposed as answer by Rama Udaya Wednesday, April 3, 2013 10:24 AM
    • Marked as answer by Maggie Luo Sunday, April 7, 2013 3:34 PM
    Monday, April 1, 2013 9:48 AM

All replies

  • Hello,

    There can only be a single endpoint for database mirroring per instance. There isn't a "default" per se as much as you're limited to a single endpoint so by that standard would have to be the "default". There is no mirroring endpoint that exists out of the box, it would have to be created after SQL Server is up and running.

    -Sean


    Sean Gallardy | Blog | Twitter

    Saturday, March 30, 2013 9:35 PM
    Answerer
  • Hi SLNSH,

    All Database Mirroring traffic is transmitted through a TCP endpoint with a payload of DATABASE_MIRRORING. You can create only one Database Mirroring endpoint per SQL Server instance.

    By default, the Database Mirroring endpoint is defined on port 5022. The database mirroring endpoint listens on a unique TCP port number. Combine TCP endpoint and a payload, I think it is the default endpoint.

    You can configure multiple SQL Server instances on a single server, and each instance can have a single Database Mirroring endpoint. However, you must set the port number for the Database Mirroring endpoint on each instance on the same server to a different port number.

    The Database Mirroring Endpoint (SQL Server): http://msdn.microsoft.com/en-us/library/ms179511.aspx.

    Thanks.  


    Maggie Luo
    TechNet Community Support

    • Proposed as answer by Rama Udaya Wednesday, April 3, 2013 10:24 AM
    • Marked as answer by Maggie Luo Sunday, April 7, 2013 3:34 PM
    Monday, April 1, 2013 9:48 AM