PostureRay Backup Steps
PostureRay Backup Best Practices
So often we have clients that will call us after a virus attack or hard drive crash to reinstall PostureRay, only to find out that they have failed to make backups of their precious data. A robust backup solution should be in place for all practice data, including PostureRay. It is not good enough to have simply one back up location either. You should always have an offsite solution as well as a local backup copy. Also, if your practice adheres to HIPAA standards you should know that backups and backup safeguards are required for compliancy.
If you operate a true server in your office please have your IT professional make sure they’re doing frequent image-based backups of the entire hard drive(s) in case disaster strikes. The Windows Server backup utility can provide a basic daily image of your system. Other products such as ShadowProtect can provide more granular images and incremental snapshots that can restore data saved to within 15 minutes of a failure. This is the best way to ensure your full server data is readily available and HIPAA disaster recovery compliant. Both of these methods should direct their backups to an external device such as a NAS, storage server or external hard drive.
Once your image-based backup solution is in place, offsite transfer or storage of backup data should be put in place in the event of a true disaster scenario. There are third party services that can facilitate this and your IT professional should be consulted on which is best. Backup services such as ShadowProtect also offer this as an option. If backing up to external hard drives, you can utilize a drive rotation scheme that keeps at least one drive offsite at all times. Again, consult your IT professional for best practice solutions.
If unable to use an image-based backup solution, there are several cloud-based data only backup solutions that are available. Among these are Carbonite, CrashPlan and Mozy. If using one of these methods, you will need to verify that all files and folders for PostureRay are included in the backup. These are typically found in C:\PROGRAM FILES (X86) for Stand-Alone PostureRay users. For users with dedicated servers, the folder is typically found on a data drive. Please contact PostureCo support if you need assistance finding your data folder. Additionally, PostureRay users can also copy and paste the entire PostureCo folder to backup media.
Servers and New Server Updated SQL Backups
PostureCo has recently begun rolling out Microsoft SQL as a new database format available with current upgrades. In addition to backing up the PostureCo Net folder on the server, you will need to also backup the SQL database. The SQL database format provides greater performance and extensibility, but also changes the location of the PostureRay data set. If using an image-based backup solution of your entire hard drive of your server, there is nothing that needs to be changed or added to ensure your PostureRay data is included. If using any of the cloud-based solutions or backing up only specific folders, you will need to verify that the PostureRay.mdf and PostureRay_log.ldf files in C:\Program Files (x86)\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA or C:\Program Files\Microsoft SQL Server\MSSQL11.SQLEXPRESS\MSSQL\DATA are also included in the backup.
If you are uncertain that you have the new SQL data format, or can’t find your SQL data, please contact PostureCo support for assistance. Please note, it may be necessary to make sure all users have exited the PostureRay application before a cloud-based solution will be able to back up the SQL data files.
Video link: http://youtu.be/hwT7bFpnOx0
PLEASE BE SURE TO WATCH THIS ENTIRE VIDEO TO SEE THE DIFFERENCES BETWEEN A NETWORKED POSTURERAY BACK METHOD VS. STANDALONE 1 COMPUTER BACK UP STRATEGY.