5

I have a two node cluster running SQL Server 2012. I want to create two Availability groups within the same instance of SQL Server.

Should I add one endpoint for each AG, or shall I allow both AG's to use the same endpoint?

I have read the documentation here but the only part pertaining to multiple endpoints relates to multiple SQL instances

Note that if more than one server instance on a given computer requires a database mirroring endpoint, specify a different port number for each endpoint.

asked May 3, 2019 at 13:38

1 Answer 1

6

If you read Prerequisites, Restrictions, and Recommendations for Always On availability groups it says

Each server instance requires a database mirroring endpoint. Note that this endpoint is shared by all the availability replicas and database mirroring partners and witnesses on the server instance.

An endpoint is for instance of SQL Server and all Availability Groups configured within that instance can use this endpoint.

answered May 3, 2019 at 13:44

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.