If you query a proxy table mapped to a table on a remote data access mirror server, the remote data access layer looks at both the SYS.SYSMIRRORSERVER and SYS.SYSMIRRORSERVEROPTION catalog tables to determine what connection string to use to establish a connection to the SA server pointed to by the remote data access mirror server.

To set up a remote data access mirror server to connect to MyMirrorServer, execute a statement similar to the following:

CREATE SERVER remote_server_name 
CLASS 'MIRROR'
USING 'MirrorServer=MyMirrorServer';