It is recommended that you keep a regular backup (once a week) of the Data Store. The backup method depends on whether an xBase or a SQL Data Store is being used.
Backing up an xBase Store
The backup solution would obtain an exclusive lock on all the files in the Store folder to ensure that the database indexes and memo fields are consistent with the database. Working Papers and Tracker only open database files when needed (i.e. when idle or no open connections to databases are maintained). However, in a large firm, it may be difficult to time the backup while no users are accessing the Data Store. For this reason, we recommend that the backup be timed to occur when it is unlikely that users will be actively accessing the store.
Backing up a SQL Store
For SQL stores, we recommend that the normally installed SQL administration tools (ex. SQL Server Management Studio) be used to perform the backup. Although it is possible to create a backup at any time using SQL, we recommend again to perform the backup it is unlikely that users will be actively accessing the store.
Restoring an xBase Store
The method for restoring from backup depends on the type of store involved. Restoring from an xBase backup simply requires all the files in the Store folder to be replaced by the backed up files. This can only be performed when no users are actively accessing the store. If it is suspected that the indexes are out of date, a Data Store repair should be run.
Restoring a SQL Store
We recommend that the normally installed SQL administration tools (e.g. SQL Server Management Studio) be used to perform a restore of SQL Data Stores. See more...