State information files

The partners and the arbiter in the high availability system each maintain a state information file that records that server view of the state of the mirroring system.

The state information file is used during startup when determining the role to be assumed by a server. The server local state is compared against that of the other servers in the database mirroring system.

You must always specify a state information file for each server in the mirroring system using the state_file option of the CREATE MIRROR SERVER statement. See CREATE MIRROR SERVER statement.

The state information file contains the following information:

Field	Description
Owner	Indicates which database server is the primary server.
State	Contains the synchronization state (one of synchronizing or synchronized) to indicate whether the server is receiving log pages or is up to date. See Synchronization states.
Mode	Specifies the synchronization mode (one of synchronous, asynchronous, or page). See Database mirroring modes.
Sequence	Contains a value indicating how many times failover has occurred on the database mirroring system. The sequence number is incremented on each role switch. It helps to determine whether a server view of the state of the mirroring system is current. See Database mirroring.

The following shows sample contents for a state information file:

[demo]
Owner=server2
State=synchronizing
Mode=asynchronous
Sequence=35

If a state information file does not exist, it is created automatically. State information files should only be modified by the database server. However, when you are resetting or re-deploying a mirror system, delete the state files.

Discuss this page in DocCommentXchange.