I just migrated from version 3 to version 5 and I just learned the hard way about backing up. Before, I used a simple program to backup the AC folder to an external hard drive and take it home. If I was gone, my nurses could it. So simple.
Now I realize the backup program will not back up because it says the MDF and LDF files are in use by the SQL server.
IS there an easier way to make it easier? I also want to use crashplan to backup online.
1. one way i could think was to back up using amazing utilities so it creates an enc file in the same folder and on my external hard drive for data only. Then I use my backup program to back up every thing else(imports). If I use amazing backup for everything, it takes 45 minutes to an hour just to back up the whole thing every day.I have to do these 2 steps just to save time. Then to back up to crashplan, I have to back up enf file and imports every day. Multiple steps.
2. another way I found out was to go into SQL server management and turn off sql server. BAck up to external drive, then turn sql server back on again. But then I will have problems backing up to crashplan if I have to put the sql sevrer back up.
Anyone have any other ideas on how to make this simple as possible?
