Verifying DSN reports Datasource not found?

Hello, thanks for looking..

I have two datasources configured on a production web server (Win IIS, CF8), one that connects to a remote database and the other connects to a local database. A web application I was in the process of migrating to a new server used the datasource that connected to the remote database as I was taking one step at a time. Yesterday became the day to make the final jump and to migrate the database, so after comparing the two databases (SQL Delta is a beautiful tool), I proceded to swap the datasources by renaming them in the ColdFusion Administrator. I renamed the datasource to the remote database to some arbitrary backup name, then renamed the datasource to the local database to the original name of the the datasource to the remote database.

JDBC, ODBC, whatever, I have probably performed these same steps hundreds of times without an issue. Yesterday, after renaming the datasource, verifying it, confirming it was working by browsing the application and seeing the noticable performance increase from accessing a local database, I was content to call to process complete.

At 3am server time however, the application began throwing errors, saying the datasource could not be found. I jumped into CF Admin to check everything out and found things just as I left them, two datasources, one named as a backup and the other the original name to the local database. When I clicked verify all however, the datasource to the local database failed, saying "Datasource could not be found".

I am curious as to what may have happened here. I don't see any cause for alarm with regards to technique as I have been using it for so long. ColdFusion server.log shows no sign of a restart. Does anyone have any clue what could have happened here? How could a datasource appear in CF Admin, yet verifying it says it doesn't exist? I resolved the problem by renaming it to something else, then renaming it back but I plan on deleting and recreating it completely this evening when traffic is lower. My only guess here is that ColdFusion updated active memory but failed when updating the registry, then something happened where things were refreshed.. But why.. and how can that be detected/avoided if true?

I have a lot of people asking me questions now, and after spending great amount of time convincing them ColdFusion is the best answer for their needs the first time around, I am having trouble doing so this second time. So thank you in advance for any help or insight..

Mike