Microsoft® SQL Server 2012 Unleashed

Identifying the Other Endpoints for Database Mirroring

To get each node in the topology to see each other, you have to identify the endpoints and listener port values to the databases involved in the database mirroring configuration (the principal and mirror). This also activates database mirroring. This process requires altering the database by using either the SET PARTNER or SET WITNESS statements within the ALTER DATABASE command. The Database Mirroring Wizard can also do this step for you, but doing it manually is easy.

We identify the unique endpoint listening port values for each endpoint that are unique within the server. They are port values 1430, 1440, and 1450 in our example.

Remember, you will be doing this after you create the AdventureWorks2012 ...