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 »

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: 422
Joined: Fri Dec 11, 2009 12:09 pm

Re: SQL Backup Questions

Post by rhaber123 »

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 »

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 »

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 »

perfect thanks!
________________________________
Joe Dindo
rhaber123
Posts: 422
Joined: Fri Dec 11, 2009 12:09 pm

Re: SQL Backup Questions

Post by rhaber123 »

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