O'Reilly logo

Microsoft SQL Server 2008 High Availability by Hemantgiri S. Goswami

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

Chapter 8: Database Mirroring

  • Question: How do I make sure which port is associated with Database Mirroring?

    Answer: Execute the following code to get the list of port(s) that are associated with the database mirroring:

    SELECT type_desc, port FROM sys.tcp_endpoints;
    GO
    
  • Question: How do I ensure that endpoints are started?

    Answer: Execute the following code to confirm whether or not the endpoints are started:

    SELECT state_desc FROM sys.database_mirroring_endpoints
    
  • Question: I am getting Error: 1418; how do I resolve this error?

    Answer: Error 1418 is related to general network error. We have to make sure that the ports we will be using to establish database mirroring are available; also make sure that the firewall are not blocking them.

  • Question: Principal ...

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