How Do You Backup Your OpenDental?

For users or potential users.
Post Reply
DrHamilton1993
Posts: 1
Joined: Sun Mar 12, 2023 10:53 am

How Do You Backup Your OpenDental?

Post by DrHamilton1993 » Sun Mar 12, 2023 11:15 am

Hi, im a new office learning to use OpenDental and I read about backing up my OpenDental folders and database.

I was curious how you guys back up your OpenDental such as:
  • What folders or methods do I need to back up?
  • How often do you back up?
  • What services or hardware do you use to back up too
  • If you use a service, whats it called and how much do you pay? Do you have an IT guy do it for you?
Thanks in advance for your advice and insight.

joergzastrau
Posts: 39
Joined: Sun Feb 27, 2022 2:53 am

Re: How Do You Backup Your OpenDental?

Post by joergzastrau » Sun Aug 11, 2024 9:12 am

Dear Dr. Hamilton,

We are using Open Dental (OD) since early 2022. Until now, we have relied on ODs manual backup method and local supplemental backups. We have tested a different backup solutions (e.g. bacula, rclone, backup to USB Stick) in parallel.

Our setup since last week is:

We backup to a secure HIPAA compliant Cloud storage (a logical drive letter) every night using the following software:

- Paragon Backup & Recovery for the A-Z folder, nightly differential backup and full backup every week.
- SQLBackupAndFTP for the SQL Database, nightly full backup.

Retention for old backups is 6 month. The costs for the cloud storage was a one time payment below 1000$ for 2TByte. We used the free versions of the two mentioned software products for testing and are now on a business plan for productive use. I recommend to request quotes for the business versions before testing.

We synchronize the cloud storage to a computer at a different location automatically and test the backup once per month on the used Thinkcenter m710q (120$ on EBay) according to the OD instructions. This Computer runs the trial version of OD. Thus, the "opendental" database must be restored to the "demo" database on the test computer. Also, the location of the A-Z folder must be eventually changed manually.

This is a low cost solution suitable for small offices and involves medium IT experience. I was first worried to rely on low-level playback of the SQL Database because OD introduced some security measures against modifying the database by third parties. We made the switch (or rather stopped using the OD native backup) because it worked for us for over two years now. This saves us some manual work.

We did not turn off the supplemental backups provided by OD. We do however store them locally rather than with OD and we have never tested if they work.

I would suggest to also consult with your companies for 3D scanning and X-Ray software on how to restore the data in case of a computer failure within a day and without paying a premium fee. This seems to be a dark area by my experience (I am guilty of not testing the backup recovery before the nightmare hit).

With best regards

Joerg

last edit: 08/11/2024 18:30

scott.filler
Posts: 6
Joined: Mon Aug 05, 2024 5:24 pm

Re: How Do You Backup Your OpenDental?

Post by scott.filler » Thu Oct 03, 2024 4:50 pm

Been using OD for 5 years and remember starting out. I do the IT in the office and worked in Tech and was a computer hobbist for my teens so I'm comfortable with most simple computer tasks, incl. networking, building pcs, installing programs. Not sure what your IT / IT support setup looks like or how big/small your practice is, but we started with one server (OD is a pretty light weight solution) a desktop for the front desk and 2 laptops for the opertories and one as a patient kiosk.

So for our setup we hardly filled up a few GB for patient data. What takes more space are the images for Xrays, IOCs, etc. Then finally any scanned documents (using MFC printer/scanners) can eat up space quickly too, so best to get up and running on sheets and do your patient forms digitally. As the previous poster mentioned there is some variability on which devices you use and which folders you need to backup, so check with your vendors. If your using the OD imaging module (we switched over about a year ago then everything remains within OD and is well documented. Just need to make sure your devices support/have twain drivers.

It took us 4+ years (without cleaning up data) to get to 100s of GBs per backup. I started with manual copies of the mysql / opendentimages / <vendor specific directory> once a month at least to a portable 1TB SSD. Then added an online offsite encrypted backup (Backblaze) that backsup the whole server daily. Make sure to restore/test your backups as well or you never know if your doing it correctly and if the backups work. I tend to spend on business grade computers like from HP or Dell, but if your on a budget you find many older PCs from the same companies on eBay for a fraction of the cost. I'm using an i5 based EliteDesk 800 PC with 16gb. I swapped out the harddrives with name brand (Samsung/WD/Crucial) SSDs. 1TB is a lot for the main drive and having lots of free space helps reduce wear on the SSD. No moving parts increases the reliabilty of the system. But the nice thing about using these name brand PCs is that you can buy 2 identical machines and keep the 2nd for testing backups and as a hotswap replacement if anything catastrophic happens. I also got a 1TB usb ssd to copy any backups to (just remember HIPAA andake sure the drives are encrypted so that if someone tries to remove them they can't access the data without the key).

There are still somethings I can improve like incremental vs full backups to save backup time and space now that my backups are getting bigger. I could get a NAS for more backup storage, but make sure to also have a plan for offsite backups for the cases where the office might be damaged (e.g. fire or weather/nature related damage). Faster interfaces like 10GB USB 3.2 to reduce copying data off the server. But hopefully by the time you get to this point your practice will be doing well so that you can also look into managed IT support. ;)

Last thing, try to use Windows server for the server from the get go. Windows Pro worked well for me till I had multiple desktops and laptops >10 accessing the server at the same time. While Pro can handle 20 similtaneous connections each client might create more than one connections.

Hope this helps. Good luck!

drtbar
Posts: 76
Joined: Wed Dec 26, 2007 6:43 pm
Location: Muskegon, MI

Re: How Do You Backup Your OpenDental?

Post by drtbar » Tue Oct 22, 2024 5:20 am

I've been using Open Dental since 2008, and used Suni for imaging until this year when I transitioned to XDR.

We also scanned all current charts into Open Dental in 2008.

We have about 300gb of data and backup to Crucial 1tb ssd harddrives daily with the Open Dental backup feature.

Sounds like you guys went a much more complicated route and trying to figure out why?

I'm also a savvy tech user and used to build computers on the side, and also built my network of 7 PCs and 1 server. We have very little hiccups, but have noticed a mild slowdown from time to time. I wonder if Windows Server would be a good idea to help with that, but also wonder if it's worth the effort since it is not a common occurrence.

Waiting to hear why the backup feature in Open Dental isn't the best option. Thanks in advance!

User avatar
drtech
Posts: 1653
Joined: Wed Jun 20, 2007 8:44 am
Location: Springfield, MO
Contact:

Re: How Do You Backup Your OpenDental?

Post by drtech » Sun Oct 27, 2024 6:47 pm

I use a linux machine to host the OD database on a ceph distributed storage system and I setup a cron job for scheduled backups and rsync to duplicate machines both local and remote. Also I have a portable hard drive that gets a copy every day as well using goodsync. Stable for years without any issues.
David Fuchs
Dentist - Springfield, MO
Smile Dental http://www.887-smile.com

Post Reply