The information in this article applies to:
This article provides information regarding various backup strategies for Tabs3 and PracticeMaster software. It discusses recommendations for standard versions of Tabs3 and PracticeMaster software as well as Platinum Versions of the software.
Note: As of Version 16, the name Client Server Version (CSV) has been replaced with Platinum, and the name STI Server has been replaced with Platinum Server. All references to Platinum, Platinum Version, or Platinum Server in this article also apply to the Client Server Versions and STI Server Versions listed above unless specifically noted.
The Tabs3 and PracticeMaster software includes a built-in back up program. The standard multi-user software includes the Back Up Data Files and Restore Data Files programs whereas the Platinum Version of Tabs3 and PracticeMaster includes the HotBackup and Restore HotBackup programs. These built-in back up programs are designed to create a temporary backup of all data files.
|
Standard Multi-User Version |
|
|
Platinum Version |
|
A more detailed comparison of the built-in back up programs can be found in R11193, HotBackup Overview. This article also provides additional information regarding HotBackup features.
It is important to note that the built-in backup programs in the Tabs3 and PracticeMaster software back up data files. They do not back up program files, nor do they back up every file in the Tabs3 program directory. You will need to use a third-party backup to back up the Tabs3 program directory for purposes of recovering from a catastrophic failure, such as fire, flood, theft, server hard drive failure, etc.
Note: When referring to the Tabs3 Program Directory, it is assumed that the Program Directory and Current Working Directory are the same. The Program Directory and Current Working Directory can be seen in the Help | About window.
When backing up Tabs3 and PracticeMaster data using standard backup software, you must observe the following in order to create a successful backup:
Additionally, when using the Platinum Version of the software, you must observe one of the following:
Note: The *.FCS files are Platinum Server files that must not be locked by other programs, such as third-party backup programs, while Platinum Server is running. Doing so can cause errors in the Platinum Software that would require restoring from an earlier backup.
When backing up Tabs3 and PracticeMaster software using a third-party backup method, all files in the database structure must be closed in order to create a valid backup. If users are in the software or do not exit the software properly, files are left open. In larger firms, it can become quite difficult to ensure that all users have closed all applications properly before every backup. Having an administrator reset users is not a good solution because it can also cause files to be left open as well as potentially introduce data corruption.
Depending on the third-party backup software being used, it typically can be configured to skip open files or wait for the open/cached files to close. Both of these options are problematic when backing up Tabs3 and PracticeMaster data files. Skipping open files in database software is not a viable solution because all Tabs3 and PracticeMaster data files must be backed up as a set. Waiting is not a good solution either because it can cause mismatched data files as well as backups that do not complete.
Making a backup that does not include all data files provides a false sense of security. This is because restoring this backup will almost certainly yield a set of data with mismatched data files and will in all likelihood include Data File Integrity Check errors, generate fatal errors, and be unusable.
Note: The above steps are generally not required when using a Volume Shadow Copy Service (VSS) in conjunction with Tabs3 and PracticeMaster Platinum software. When using Platinum software, any backup software that utilizes VSS can create a VSS backup, or snapshot, without users exiting the software, stopping the Platinum Server service, or excluding .FCS files. Additional information on using VSS can be found in KB Article R11430, "Using Volume Shadow Copy Service (VSS) to Back Up Tabs3 and PracticeMaster Software".
The following discusses additional backup strategies as they relate to making third-party backups when using Platinum Version software.
The following table summarizes two different third-party backup options that can be used if you want to rely on a third-party backup as a stand-alone backup. Option A requires shutting down the Platinum Server and Option B allows the Platinum Server to remain running but requires you to exclude *.FCS files. Note that both options require all users to exit the Tabs3 and PracticeMaster software.
|
Option A |
Option B |
|
|
When making a third-party backup, backing up your data files requires that all users exit the Tabs3 and PracticeMaster software. In many situations, it may not be practical to have all users exit the software. This is one of the primary reasons why we developed HotBackup.
It is possible to implement a backup strategy that allows for users in the Tabs3 and PracticeMaster software. This strategy requires either using a third-party backup and HotBackup together, or a Volume Shadow Copy (VSS) backup solution. When using a third-party backup and HotBackup, it also may require restoring from both a third-party backup and a HotBackup in the event it is necessary to restore.
|
Option C - Skip Open Files |
Option D - Volume Shadow Copy (VSS) Backup |
|
|
It is extremely important to note that files are open when users are in the Tabs3 and PracticeMaster software. If open files are skipped during a third-party backup, the third-party backup is not valid as a stand-alone backup because all data files must be backed up as a set of data files at the same time. However, any Tabs3 or PracticeMaster data files that are skipped because they are in use will be included in the HotBackup. Therefore, although the third-party backup by itself is invalid, restoring a HotBackup immediately after restoring a third-party backup addresses these issues. Alternatively, VSS can be used to create a snapshot of the database even while users are in the software. Additional information on using VSS can be found in KB Article R11430, "Using Volume Shadow Copy Service (VSS) to Back Up Tabs3 and PracticeMaster Software".
Note: For best results, this technique requires that the HotBackup be made directly before the third-party backup as discussed in the Scheduling Backups section.
Skipped Files Note: When using this method, it is important to be aware of the files that are not included in HotBackup.
In the event you need to restore a third-party backup on top of a current Platinum Version installation, you must delete the existing *.FCS files before restoring the backup. The following outlines the sequence of events.
|
Restoring Third-Party Backups |
|
Regardless of which backup strategy you implement, when scheduling backups, it is important to observe the following:
A HotBackup includes all of the Tabs3 and PracticeMaster data files you would need to restore your Tabs3 and PracticeMaster data set. However, HotBackup is not intended to be a full backup of the Tabs3 program directory. The Tabs3 program directory includes some files that are not included in the HotBackup that you may want recovered in the event you would need to restore. Therefore, it is important to periodically back up the entire Tabs3 program directory and HotBackup folder using a third-party backup method that does NOT skip open files.
The following files from the Tabs3/PracticeMaster program directory (and all folders under the program directory) are not included in the HotBackup:
Locked Files: Some third-party backup software programs, such as Backup Exec software by Symantec, allow you to configure the backup to lock files while they are being backed up. Do NOT enable this option. This option can cause fatal errors if the backup is performed while the Tabs3 and PracticeMaster software is running or while the Platinum Server and STI Director are running. Instead, configure the backup software to skip open files and use HotBackup in addition to your third-party backup as previously discussed in Option C.
Incremental Backups: We recommend not using incremental backups of the Tabs3 folder because of potential issues that can occur with mismatched data files.
If I'm using Platinum, can I simply back up my HotBackup folder and not back up the Tabs3 program folder?
You could; however, you run the risk of not having a current backup of the files that are not included in a HotBackup. We recommend periodically backing up the entire Tabs3 program directory (and all folders under the program directory).
THE INFORMATION PROVIDED IN THE SOFTWARE TECHNOLOGY, INC. KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. SOFTWARE TECHNOLOGY, INC. DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL SOFTWARE TECHNOLOGY, INC. OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF SOFTWARE TECHNOLOGY, INC. OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.
© 1999-2012 Software Technology, Inc. All rights
reserved. Terms of Use
The maker of Tabs3 and PracticeMaster
Tabs3, PracticeMaster, and the “pinwheel” symbol (
) are registered trademarks of Software Technology, Inc.
e-Mail Suggestions for the Knowledge Base to: kb@Tabs3.com
Technical Support via e-mail is not available.
Knowledge Base: http://support.Tabs3.com
Web Site: http://www.Tabs3.com