SQL Backup Questions

For users or potential users.
Post Reply
User avatar
JDs
Posts: 20
Joined: Sun Oct 02, 2011 3:59 pm
Location: Shelby Township, MI
Contact:

SQL Backup Questions

Post by JDs » Sun Sep 25, 2016 8:51 am

Is is sufficient to make a copy of the SQL folder as a backup?
Would those folder copies be legitimate backups if done during the day while someone is in OpenDental?
________________________________
Joe Dindo

rhaber123
Posts: 415
Joined: Fri Dec 11, 2009 12:09 pm

Re: SQL Backup Questions

Post by rhaber123 » Sun Sep 25, 2016 10:39 am

C:\mysql\data\opendental
I back the open dental folder only from the MySQL, it works even if someone is using OD files.
Daily, 1 hour before the end of the day, I have a software that automatically back it up, encrypt it, and sync it to another location

C:\OpenDentImages
And once a week, I do the same for the A to Z folder

User avatar
JDs
Posts: 20
Joined: Sun Oct 02, 2011 3:59 pm
Location: Shelby Township, MI
Contact:

Re: SQL Backup Questions

Post by JDs » Sun Sep 25, 2016 6:18 pm

What program are you using?
________________________________
Joe Dindo

KevinRossen
Posts: 293
Joined: Mon Apr 22, 2013 8:49 am
Location: Dallas, TX
Contact:

Re: SQL Backup Questions

Post by KevinRossen » Mon Sep 26, 2016 8:43 am

JDs wrote:Is is sufficient to make a copy of the SQL folder as a backup?
Would those folder copies be legitimate backups if done during the day while someone is in OpenDental?
Only way you can know is if you test your backup by doing a restore. I suggest trying it on an off-site computer like your home. Here's an article from Open Dental's manual on the steps to follow:
http://opendental.com/manual/backupsmanual.html
Kevin Rossen
Office Manager, Rossen Dental
Founder, DivergentDental.com
Image

User avatar
JDs
Posts: 20
Joined: Sun Oct 02, 2011 3:59 pm
Location: Shelby Township, MI
Contact:

Re: SQL Backup Questions

Post by JDs » Mon Sep 26, 2016 8:54 am

perfect thanks!
________________________________
Joe Dindo

rhaber123
Posts: 415
Joined: Fri Dec 11, 2009 12:09 pm

Re: SQL Backup Questions

Post by rhaber123 » Tue Sep 27, 2016 12:38 am

WinZip®20.5 PRO
http://www.winzip.com/winzip-feature-co ... ml#sub-nav

Encrypt/Decrypt
Secure sensitive data with strong, FIPS-197 certified AES encryption (128- and 256-bit)
Establish your own password policy by defining complexity requirements

Access all your files from your PC, network, Windows HomeGroup and supported cloud services via the Places list

Post Reply