Specifies the name of a mirror server, allowing you to maintain database availability if a failover event occurs.
SNC SQL Native Client for Microsoft SQL Server
FailoverPartner =value
Parameter |
Description |
---|---|
value |
Specifies the name of a mirror server. |
None
When failover occurs, the existing InfoMaker connection to SQL Server is lost. The SNC driver releases the existing connection and tries to reopen it. If reconnection succeeds, InfoMaker triggers the DBNotification event. The following conditions must be satisfied for InfoMaker to trigger the failover event:
The FailoverPartner DBParm is supplied at connect time
The SQL Server database is configured for mirroring
InfoMaker is able to reconnect successfully when the existing connection is lost
When failover occurs:
InfoMaker returns an error code (998) and triggers the DBNotification event with notification type DBFailover!
Existing cursors cannot be used and should be closed
Any failed database operation can be tried again
Any uncommitted transaction is lost. New transactions must be started
To set the name of a mirror server to use in the event of a failover, type the name of the mirror server in the Failover Partner text box on the System page of the Database Profile Setup dialog box.