Coldfusion server reinstallation or cloning is a common scenario however if your server is the type with multiple data sources, recreating those DSNs could be hell on earth – especially when you have a world cup match to watch.
All you need do is back-up of CFROOTruntimebinneo-datasources.xml. This XML file is where CF stores the data source settings for all DSNs. Mind you, the passwords are encrypted.
or simply go to c:ColdFusion8lib and copy the neo-datasource.xml from one server to another if you using coldfusion 8, 9 and above….