My current setup has 3 servers. My primary App server, My Database server, and My Hot Standby server.
My current setup works as designed. If my primary stops the hotstand by kicks in immediately. However, I want to take it one step further.
My Hot Stand by server is located off site at our Business Recovery location in the event of a disaster. However, in the event of a real disaster I'd lose my on site DB server as well. So my question would be, While there is a Hot Standby Polling engine, Is there a Hot Standby DB server?
If not, Is there a way to point the Hot Standby engine to a second (redundant) Database?