Home Forums Discussions General Discussion my new machine--reinstalling the database.

OK, so I am still "in trial" with AC, and have not really been using the scheduling function yet. My weekly planner has always worked well for me, but I would like to eventually move to AC scheduling.

Problem is, I had scheduled slots all set to go. Then, as I mentioned elsewhere, I got a brand new main computer (and the SSD is lightening fast!).

My IT guy, bypassed whatever is the proper method of restoring my local backup and saved the databases to the directories after re-installing the ac.exe software.

I got my database up but I don't get a schedule. And when I re-run the schedule setup, it seems to setup schedule slots for me but they do not show up in AC at all--just a blank page.

So my question is how to resolve that. Of course this week I will call up Dan or Nick if no one can help. But what is the proper method for restoring a backup after re-installing AC???

Sorry I haven't done that yet, ask Bert. He knows.

Hopefully you have a backup made just before the reinstallation. Run the backup restore program and use this backup and all should be as it was. Apparently one of the scheduling files is in the wrong place. Easiest way is to do a backup restore. Takes about 30 to 60 minutes depending on it's size, given that you are new, it should be quick

Thanks, but the golden question is: "where is the 'backup restore program?" I don't think it's part of AmazingBackup.

You can find the restore program inside C drive, program, AC. It's a green icon. You can find you back up ENC file inside the Backup folder in AC. If you don't see it. You can do a back up at the old computer, then copy to the new one and run the backup restore utility.

I'm also 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?