Hello all,
First time here, unfortunately for a call for help. I'll give a quick run down of the situation. The office came to the conclusion that it was time to upgrade our server. Nothing fancy at all, Dell PE T20 w/ E3-1225 v3, 20GB ram, running Server 2012 R2. The old server was Server 2008 R2.
I migrated all the users, shares, etc. to the new server. Over a weeks time I verified everything was copacetic on that front. Well, the doctor has a hosted EMR but he also likes to keep the data in Amazing Charts locally just in case we lose internet for an extended period of time so he still has access to patient information. He copies this data manually, just FYI. The decision was made to migrate AC to the new server and that would allow us to retire the old as that was the only thing it was doing now.
On the old server I created an AC backup. No big deal, everything went as expected. Installed AC on the new server, created a dummy practice, and imported the backup. I had to open ports in the firewall to allow access to SQL from his computers but other than that it all went fine. However, over the last week I've been trying to create a backup of the database on the new server. The AC backup utility runs, says its creating a backup, and about 10+ minutes later errors outs with a message like "Backup error, check backup log".
It creates the BACKUP folder in the AC folder, and even the folder inside that for that backup instance. I've checked security permissions on the folder, even as far as to make sure Everyone, Admins, the SQL acct etc has Full access but to no avail. I also can't find any type of log if it is actually creating one.
Its probably very important to note he's still running 5.0.29. I have no idea why hes still running such an old version, but it was working fine on the old Server 2008 server.
I'd appreciate any help/ideas anyone can offer.
Thanks in advance,
Tristan