I'm having problems setting up a backup machine. Basically, I want to use my backup to set up a new database on a different machine to see if I am set up for disaster recovery - ie. crashed hard drive or stolen machine.
I could use the Amazing Backup program with the monolithic .enc file, but this file doesn't work with my offline backup (at 14 gb too large for daily passage over the internet). Plus the Amazing Backup program continually puts extra backups in the Amazing Charts/Backup directory, which quickly fills up the server hard drive (a bad thing).
So my off site backup backs up the changed files in the Amazing Charts directory every night, including good shadow copy of open files. So here's what I've tried to do -
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?
