O'Reilly logo

Microsoft® SQL Server 2012 Unleashed by Alex T. Silverstein, Chris Gallelli, Paul T. Bertucci, Ray Rankins

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required