-xp iqsrv16 Database Option

Provides information to an operational server that allows it to connect to its partner and to the arbiter when database mirroring is being used.

Syntax

iqsrv16 [ server-options ] database-file  -xp on

Remarks

The -xp database option must be specified after the database-file, and applies only to that database.

If the connection parameters specified in the -xp option are invalid, and there are multiple databases running on the server, then the mirrored database fails to start and does not attempt to reconnect. If the mirrored database is the only database running on the database server, then the database server does not start.

on – You can only use database mirroring if you specify the -xp option when the database server is started, even if mirroring information is stored in the database. When you specify -xp on, you cannot specify other mirroring options with the -xp option. The value off is not supported. Database mirroring settings are defined in the database using the following statements:
- CREATE MIRROR SERVER
- SET MIRROR OPTION
When you specify -xp on, you should also specify the name of the database server in the mirroring system using the -n option. It is also recommended that you also include the -su option to specify the password for the utility database. Then, you can use the utility database to shut down the database server, or force the mirror server to become the primary server, if necessary.