Database scheduled auto backup and its scheduled time

Most Recent Posts

I won't get help because I am I
by JBS - 04/18/2025 10:53 PM

AC Version 12.3
by ChrisFNP - 04/15/2025 10:22 AM

An automated process failed: MedsUdates
by ChrisFNP - 04/15/2025 10:12 AM

New Feature?
by ChrisFNP - 04/11/2025 11:41 AM

Pharmacy Request Counter Issues
by Headcase - 04/08/2025 7:04 PM

phantom printer
by imcffp - 04/08/2025 10:26 AM

AC v12 mandatory upgrade
by ChrisFNP - 04/01/2025 9:47 AM

Calculating sigs for Peds and FP
by Wendell365 - 03/28/2025 12:59 PM

Member Spotlight

koby
Canaan CT

Posts: 835
Joined: May 2009

Newest Members

It's me, Paradise Family, MedCode, MZ Medical Billi, girlfromwebpage
4,593 Registered Users

Print Thread

Rate Thread

Database scheduled auto backup and its scheduled time #73165 08/11/2018 11:42 PM
Joined: Aug 2018 Posts: 4 Western New York buffalobill OP Member
OP buffalobill Member Joined: Aug 2018 Posts: 4 Western New York	Hello amazing forum, I signed up to ask if this phenomenon is AC related or server related. Currently, I am supporting a client who uses AC EHR/EMR/PM. I have set the auto backup schedule as 12:01am. I am noticing the following time entries. Quote PracticeName_client#_mmddyy_120102 PracticeName_client#_mmddyy_120112 PracticeName_client#_mmddyy_120114 PracticeName_client#_mmddyy_120120 PracticeName_client#_mmddyy_120124 PracticeName_client#_mmddyy_120125 PracticeName_client#_mmddyy_120132 PracticeName_client#_mmddyy_120141 PracticeName_client#_mmddyy_120143 PracticeName_client#_mmddyy_120147 PracticeName_client#_mmddyy_120152 PracticeName_client#_mmddyy_120158 PracticeName_client#_mmddyy_120206 PracticeName_client#_mmddyy_120212 PracticeName_client#_mmddyy_120220 PracticeName_client#_mmddyy_120229 PracticeName_client#_mmddyy_120229 PracticeName_client#_mmddyy_120233 PracticeName_client#_mmddyy_120241 PracticeName_client#_mmddyy_120249 PracticeName_client#_mmddyy_120254 PracticeName_client#_mmddyy_120255 PracticeName_client#_mmddyy_120304 PracticeName_client#_mmddyy_120314 PracticeName_client#_mmddyy_120322 PracticeName_client#_mmddyy_120326 PracticeName_client#_mmddyy_120329 PracticeName_client#_mmddyy_120330 PracticeName_client#_mmddyy_120336 PracticeName_client#_mmddyy_120345 PracticeName_client#_mmddyy_120349 PracticeName_client#_mmddyy_120355 PracticeName_client#_mmddyy_120401 PracticeName_client#_mmddyy_120403 PracticeName_client#_mmddyy_120405 PracticeName_client#_mmddyy_120406 PracticeName_client#_mmddyy_120407 PracticeName_client#_mmddyy_120408 PracticeName_client#_mmddyy_120412 PracticeName_client#_mmddyy_120422 PracticeName_client#_mmddyy_120424 PracticeName_client#_mmddyy_120430 PracticeName_client#_mmddyy_120437 PracticeName_client#_mmddyy_120445 PracticeName_client#_mmddyy_120448 PracticeName_client#_mmddyy_120456 PracticeName_client#_mmddyy_120458 PracticeName_client#_mmddyy_120503 PracticeName_client#_mmddyy_120508 PracticeName_client#_mmddyy_120513 PracticeName_client#_mmddyy_120522 PracticeName_client#_mmddyy_120524 PracticeName_client#_mmddyy_120529 PracticeName_client#_mmddyy_120532 PracticeName_client#_mmddyy_120535 etc, etc... While this might be an insignificant time delay, I am curious to know if this is AC timer related or server execution related? Why would the scheduled auto database backup delay like this? Normally, it would not matter much but I also wrote a script to wait 2 hours after the scheduled backup and copy to off-site storage. The copying progress takes very long and I would like to have it done before office opens (7am.) So, if the scheduled backup is delayed everyday by about 5-30sec, or about 1 minute delayed every 10-13 days, then at some point it will be delayed 30min, 60min, etc. And, I am not the full time support for this clinic so "resetting" the backup time would not be possible for a very long time. Besides, the timer should not be this off I would appreciate any insight or correction of the program. Thank you.

Re: Database scheduled auto backup and its scheduled time buffalobill #73178 08/15/2018 11:48 PM
Joined: Sep 2012 Posts: 342 Likes: 7 carlfogel Member
carlfogel Member Joined: Sep 2012 Posts: 342 Likes: 7	Hi, Maybe over those 50+ days the backup's preliminary checks of the slowly growing AC database (and possibly the separate hideous imported items folder) are taking longer and longer? That is, maybe the AC backup program is still starting exactly on time, but it might be taking longer and longer to reach the point where it gets around to creating the actual backup file and uses this delayed creation-time the file-name. Windows defaults to just hh:mm displays, but you can see the modified/created/accessed times in hh:mm:ss with the free nirsoft bulkfilechanger.exe. You can get the current nirsoft utilities zip file, whose password is nirsoft9876$ (to avoid pesky false positives from anti-virus programs) from www.majorgeeks: https://www.majorgeeks.com/files/details/nirlauncher.html Or you can wrestle with wmic to get hh:mm:ss data: https://superuser.com/questions/937380/get-creation-time-of-file-in-milliseconds In any case, the time when the backup finishes after your specified 12:00 start time may be what really matters. With AC, backups should take longer and longer to finish as data (and maybe imported items) are added. Cheers, Carl Fogel

Re: Database scheduled auto backup and its scheduled time buffalobill #73189 08/17/2018 4:50 PM
Joined: Aug 2018 Posts: 4 Western New York buffalobill OP Member
OP buffalobill Member Joined: Aug 2018 Posts: 4 Western New York	Thanks for the reply, Carl. I can understand what you are saying. As the database grows, it requires longer time to get the backup ready for encryption. And perhaps the starting time could be delayed due to growing size. But, I was looking at the from Task Scheduler--starting time of any automation should be the same day after day. So I am attaching the screenshot of Amazing Charts' backup screen. As you can see, even though it was set to 12:01am from the beginning it has now changed to 12:06am. It has modified itself with delayed start time. If my Windows Task Scheduler did that on its own I would be very worried that a scheduled task is rewriting its own starting time. I was just curious if any users here is worried, how they have corrected the problem or even is aware? This client is not cloud based but local server based. AND, the total backup time is still 57 minutes (including imported files). So, if it starts at 12:01am then it ends at 12:58am. If it starts at 12:06am, it ends at 1:03am. So far the total time to prep and encrypt the auto data backup is 57 minutes. Perhaps a general question I should search/start is how do you manage auto backup and when do you clean out old backups? For my client, I have wrote a program to delete older than 60 days and placed that as Windows Task Scheduler. But, maybe that would be for another topic.

Re: Database scheduled auto backup and its scheduled time buffalobill #73192 08/17/2018 5:55 PM
Joined: Sep 2012 Posts: 342 Likes: 7 carlfogel Member
carlfogel Member Joined: Sep 2012 Posts: 342 Likes: 7	Hi, Very interesting screen shot of the apparent change in time of execution--thanks. Have the backup files gotten larger? I'd be even more worried if an AC backup of data and imported items took the same 57 minutes to finish after more than 50 days of normal office activity. It almost seems as if 6 minutes has slowly been added (in a confusing way) to the entire backup task. Those small but random-size time-increases in the apparent start-time look awfully like a backup-program dealing with daily data growth. Your original post suggests that you may not have remote access, but if you do, you could connect, start task manager around 11:55 p.m., and watch to see whether the AC backup starts hogging the CPU and disk-activity at midnight or six minutes later. As for the annoying problem of automatically deleting old AC backups, this AC forum usually recommends the free autodelete program from CyberD: https://www.majorgeeks.com/files/details/cyber_ds_autodelete.html It's a good idea to try your autodelete settings on a test folder to make sure that it works the way that you want. Cheers, Carl Fogel

Re: Database scheduled auto backup and its scheduled time buffalobill #73193 08/17/2018 6:19 PM
Joined: Jun 2009 Posts: 1,811 Western US Indy Member
Indy Member Joined: Jun 2009 Posts: 1,811 Western US	Have you tested some of the backups for restoration? It has been our experience that very large .enc files, especially those including imported items have a larger failure rate than those only contain the DB backups. YMMV, but testing some of them for restoration will give you a baseline for that practice. Indy "Boss" Indy's Blog www.BestForYourPractice.com Our Name is Our Creed

Re: Database scheduled auto backup and its scheduled time buffalobill #73205 08/20/2018 1:18 PM
Joined: Aug 2018 Posts: 4 Western New York buffalobill OP Member
OP buffalobill Member Joined: Aug 2018 Posts: 4 Western New York	Hello to all and especially to programmers, I believe there is something seriously wrong with auto database backup program. Take a look at this screen shot. It changed itself to the time of 11:51 AM! If it went back to original time of 12:01am I would understand...but now the backup is happening in the middle of the day!! I seriously suggest the programmers of Amazing Charts to review this issue and address it rather quickly. Otherwise, users of this program may not even know why local server may be slow at times. Has anyone ever noticed this or am I making a big fuss over minor thing?

Re: Database scheduled auto backup and its scheduled time buffalobill #73997 03/31/2019 6:49 PM
Joined: Mar 2012 Posts: 195 Naeem Member
Naeem Member Joined: Mar 2012 Posts: 195	I have similar issues. We moved AC hosted service and the backup utility messes up every time I try to backup import items. The utility runs at odd times, the backup starts failing and ultimately the AC / Sql server stops working. THE AC tech support has to be involved to get it fixed. I am told that I do not need to worry about the import items and in the worse case scenario, I will lose only 24 hr worth of work but it makes me nervous.The backup utility remains stuck even after I uncheck import items and reset the backup tome. Any suggestions??

Moderated by ChrisFNP, DocGene, JBS, Wendell365

Link Copied to Clipboard

ShoutChat

Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.

Home Forums Discussions Feedback and Recommendations Database scheduled auto backup and its scheduled time