Actually, no. I found that you cannot automatically create a 2000 compatible Backup file.
There is a complicated workaround that involves outputting to SQL Statements with the 2000 Compatibility option checked, and then running those statements on the 2000 server. I ran into the problem trying to have a database created in 2005 backed up and restored in a 2000 server. The 2000 server had problems restoring the backup. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Check out the new features and enhancements in the latest product release - download the "What's New PDF" now http://download.macromedia.com/pub/labs/coldfusion/cf8_beta_whatsnew_052907.pdf Archive: http://www.houseoffusion.com/groups/CF-Community/message.cfm/messageid:248146 Subscription: http://www.houseoffusion.com/groups/CF-Community/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5
