Copy node parent determination

A copy node determines what server to connect to by looking in the ISYSMIRRORSERVER system table for its own mirror server definition and seeing what its parent value is.

  • Null means the copy node's parent is the root node.

  • If there is an ID in the parent column, then the server with that ID is the copy node's parent.

Once the copy node knows which server is its parent, it uses the connection_string option value stored in the database to connect to the correct parent.

 Determining the parent of a copy node in a database mirroring system
 See also