-xp database option

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

dbsrv16 [ server-options ] database-file
-xp { on | mirror-settings }

mirror-settings :
partner=( partner-conn );
auth=auth-str;
[ ;arbiter=( arbiter-conn ) ]
[ ;mode=[ sync | async | page ]
[ ;autofailover=[ YES | NO ] ]
[ ;pagetimeout=n ]
[ ;preferred=[ YES | NO ] ...

All operating systems, except Windows Mobile
Network server only

When you specify -xp, you must also specify the location of the database mirroring state information file with the -xf option. 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 and/or scale-out if you specify -xp option when the database server is started, even if mirroring or scale-out information is stored in the database. When you specify -xp on, you cannot specify other mirroring or scale-out options with the -xp option. The value off is not supported. Database mirroring and scale-out 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.
partner-conn (deprecated) Specifies the connection string for the partner server. A user ID and password are not required. It is recommended that you specify a timeout to reduce failover time.
auth-str (deprecated) Specifies the authentication string used by the arbiter.
arbiter-conn (deprecated) Specifies the connection string for the arbiter server. A user ID and password are not required. It is recommended that you specify a timeout to reduce failover time.
mode (deprecated) Specifies the synchronization mode used for database mirroring: synchronous (sync), asynchronous (async), or asyncfullpage (page).
autofailover (deprecated) Specifies whether the mirror server automatically takes over as the primary server when the original primary server goes down. This option does not apply to synchronous mode.

Note

It is recommended that if you are using asynchronous or asyncfullpage mode, that you set the -xp autofailover option to yes. Then, if the primary server goes down, the mirror server automatically takes over as the primary server.
pagetimeout (deprecated) Specifies how often, in seconds, transaction log pages are sent to the mirror server, whether or not they are full. This option applies only when using asyncfullpage mode.
preferred (deprecated) Specifies whether the server is the preferred server in the mirroring system. The preferred server assumes the role of primary server whenever possible. This is equivalent to specifying the preferred option in the CREATE MIRROR SERVER statement. See Preferred database server in a database mirroring system.

Caution

In asynchronous and asyncfullpage mode, committed transactions are not guaranteed to be recorded on the mirror server, and it is possible for data to be lost. See Database mirroring modes.

The following command starts three database files on a database server that is available to participate in a mirroring system:

dbsrv16 -n server1 -x tcpip(PORT=6871) -su sql
c:\server1\one.db -xp on c:\server1\two.db -xp on c:\server1\three.db -xp on

-xp database option

Syntax

Syntax (deprecated)

Applies to

Remarks

Note

Caution

See also

Example