GET_MIRROR_SERVER¶

Applies to: SQLFlex

This command is used to get the name of the server and database being used for failover mirroring. Mirroring must be properly set up in SQL Server for this command to return the correct values.

Syntax

GET_MIRROR_SERVER to {server} {database}

Parameter	Description
server	Variable to hold the name of the mirrored server
database	Variable to hold the name of the mirrored database

Example

GET_MIRROR_SERVER to sServer sDatabase

SET_MIRROR_SERVER