Greetings, My boss has asked me to come up with a plan of action in case one of our databases is off line or if we loose connectivity to it. In this setup we have one DB in one location and another one at a different ISP. I think he wants a solution in which if its possible that CF would be able to make the change if some sort of situation were to occur and we can't reach site A.
One thing that I thought of would be to run a simple query and if it times out or we get a DB error then we would switch to the alternate DB. I have just started thinking about this scenario and since I have never been tasked with this type of challenge before I thought I would ask. Thanks, Mallory Woods ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346867 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm