Subject Failover Strategies
Author John Peterson
I wish to have an application fail over automatically to a backup server in the event that the primary fails (power fail, IB failing, LAN failing etc.), specifically to know if the primary is operating.

The application uses IBO, and DML Caching, allowing the server to "push" table changes out to the clients without the client continually polling the server.

I would be interested to hear how people implement a low cost "ping" request to the server. A simple query, or call to a SP may be best, since it would test all required systems.


[Non-text portions of this message have been removed]