FileCabinet CS: Backing up FileCabinet CS SQL database

Alerts and notices
Leave feedback

Internal Employees: Submit feedback

Contact information (optional):

Leave this blank:

Please tell us how we can make this information more helpful.


Characters left:

For more information on the SQL database format in FileCabinet CS, see Data File Format Alternatives (Standard vs. SQL).

Due to the dynamic nature of SQL databases, most tape backup systems will skip a SQL database in the normal nightly run.

FileCabinet CS Development released a database backup system to create files that tape backups can access. The database backup includes all drawer data and system settings associated with the database data location, such as the document names list, in one seamless process. In the event you need to restore the database, all drawer data and system settings associated with the data would be restored.

Due to potential SQL authentication errors and other conflicts that may render backup data unusable in FileCabinet CS, it is highly recommended that FileCabinet CS' SQL data location backup and restore features be utilized in lieu of SQL Server Management Studio whenever possible.

To back up database data locations, choose File > Backup, choose Database Locations from the drop-down list, and then select the database data location(s) to back up. A backup of the database will be placed in the selected location in a folder called, fcabdatadb_backups. To restore database locations, choose File > Restore and choose Database Locations from the drop-down list. The backup and restore processes may take a significant amount of time, depending on the size of the database.

Note: The selection of individual drawers is not available when backing up or restoring the full database. To back up or restore individual drawers that are stored in a database location, choose File > Backup or File > Restore and use the default Drawers selection that appears in the drop-down list.

You can also set FileCabinet CS to automatically create these backups on a recurring basis, saving them to a convenient location for your nightly backup system.  For more information see, Scheduled Backup dialog.

The recurring backups will create up to 10 file backups. Once it hits the 11th, it will circle through the file names again and start overwriting the first. The file names for the backups will end with [SB0].bak, [SB1].bak...etc

Note: Because an SQL database holds all the data for any of the above programs in one database file, it is not possible to restore specific files or clients. You have to restore the whole database file, which includes all files and clients.

Share This