When you first set up a database mirroring system and there are no state information files, and the copies of the database and transaction log are identical, both servers are eligible to act as the primary. In this situation, the server names are compared, and server with the lower name acts as primary. For example, the name server1 is lower than server2.
For the initial startup, both servers must be running and connected for them to agree on roles; the presence of an arbiter is not sufficient since the prior state information recorded in the state information files does not exist.
During a normal startup, the following inputs affect which server becomes the primary server:
Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |