Connect to the primary server. Run the following command:

dbisql -c "UID=DBA;PWD=sql;SERVER=mirror_demo_primary;HOST=localhost:6871,localhost:6872" 

Use the ServerName database server property to determine the name of the server that is currently the primary server.

SELECT PROPERTY( 'ServerName' );

The name of the primary server appears (mirror_server1).

The ServerName database server property returns the real name, not the alternate name, of the server.

Initiate the failover by executing the ALTER DATABASE SET PARTNER FAILOVER statement

ALTER DATABASE SET PARTNER FAILOVER;

Connections to the primary server close. The database server messages window for server2 displays a message indicating that it is the new primary server:

Connect to the current primary server:

dbisql -c "UID=DBA;PWD=sql;SERVER=mirror_demo_primary;HOST=localhost:6871,localhost:6872"

Execute the following statement to verify that the server that was previously acting as the mirror server (mirror_server2) is now acting as the primary server:

SELECT PROPERTY ( 'ServerName' );

Execute the following statement to verify that all transactions were mirrored to the mirror database:

SELECT * FROM test;

Disconnect from Interactive SQL.