SET_MIRROR_SERVER¶

Applies to: SQLFlex

This command is used to programmatically set the mirror server for the database. This is to be used along with SQl server failover mirroring. Note that this simply sets the server and database to be used for mirroring. All set up for the servers must already be working properly through SQL Server.

Syntax

SET_MIRROR_SERVER to {server} {database}

Parameter

Description

server

The name of the mirror server

database

The database acting as a mirror

Example

SET_MIRROR_SERVER to "(localdb)\v11.0" "MirrorDB"