1. Fresh install of AC, with dummy practice, on new main computer.
2. Restore from offsite backup to different directory (AC2) on new main computer.
2. Disconnect the SQL database using the Advanced Options on Amazing Utilities.
3. Reset the path.
4. Start up AC and point to the AC2 directory.
5. Get an unable to connect to SQL database error every time.
I've checked and the appropriate mdf and ldf files are there. Why won't it connect?
I tried just moving files and it did not work. There is some change that occurs in SQL settings that you need backup restore to accomplish.
Try doing backup and use the option to exclude your import items. Then do a restore and copy the import folder separately. I suspect this should work.
In practice you will send your backup out minus imports and periodically copy your imports to be available for an emergency.
You could use another program to backup your import item folder only either to another computer on the system or over the internet, which may take too long.
When you say AC2 do you mean the AC folder is named differently or just that it's on the dummy machine? AC can be occasionally finicky about changing the folder name too much (although I have one called Amazing Charts New and it works) Make sure this is not an issue as well