Viewing By Day : November 15, 2004 / Main
November 15, 2004
Recipe for Disaster
Last week, I was updating our disaster recovery plan for our public website and ran into an interesting "problem" with recovering ColdFusion. As part of our planning, we regularly go off-site to our disaster recovery provider's facility and bring up various systems as if we had to recover from a real disaster.

In my case, after the network and operating systems were in place, it was my job to bring our public website back up. This consisted mainly of installing anc configuring Apache and ColdFusion, then restoring the actual code from tape. The Apache install wen't smoothly. ColdFusion, however, threw me for a loop. We have media disks that are part of our disaster recovery packages, and mine had Apache, CF MX 6.1 and the new updater as well as a recent copy of our httpd.conf file, a CAR file containing the CF server config, and third party database drivers.

When I went to actually install CF, the installer threw up an error saying that I needed MDAC 2.6 SP2 or later in order to complete the install. Apparently, a fully patched OS doesn't contain the latest MDAC. The simple solution would have been to just go out to Microsoft's Data Site and download the latest MDAC driver. Problem was, we had no Internet circuit. We had brought it down a few hours prior to simulate a loss of our eVPN with our main campus. There were no other Internet connections available to us at that point!

In the end, we ended up running over to a coworker's appartment and downloading the driver to a USB flash drive. Once I had that, I had CF installed and configured in about 20 minutes, and the site restored from backup in about another 30 minutes.

The moral of the story here is that if you are planning a disaster recovery plan for CF, you need to include the latest MDAC in your media, as it isn't included with the CF install!