Data Locations overview

Alerts and notices

You can add and maintain data locations for different types of FileCabinet CS data. For example, you could maintain separate data locations for personal, firm-specific, and client-specific information.

Data storage formats

You can store FileCabinet CS data in the standard file format or the SQL database format. Before you determine which format to use, consider the following options.

Storage option Details
Standard file format If you have a small amount of data and few users, this option may be appropriate for your firm. This is the default format for data in FileCabinet CS.
Microsoft SQL Server Express SQL is a free database application, and as such, Microsoft places limits on its use by limiting the database size. We recommend this solution if the FileCabinet CS data for your firm requires less than 100 GB of storage space per data location.
Microsoft SQL Server Standard or above This option is appropriate if your firm requires more than 100 GB of storage space and has 15 or more FileCabinet CS users. Consult with your systems administrator to determine which edition of SQL Server is suitable for your firm.

Data location statistics

Use the following procedure to view data location statistics.

  1. Choose Setup > System Configuration and click the Data Locations tab.
  2. Click the Stats button.

    Statistics for all data locations appear at the top of the dialog. Statistics for individual data locations appear in the list in the lower half of the dialog.

  3. Click OK to close the Data Location Stats dialog.

Managing data locations

When a data location is added there are actions you can take to manage it such as, Deleting a data location or Renaming a data location.

Adding, deleting, renaming, and moving data locations does not remove any data from the specified location.

Adding data locations

You can create additional data locations to organize and split up your data to improve performance in FileCabinet CS. You can choose to create these locations in either the default standard file format (flat files) or in a Microsoft SQL Server format. Consult with your systems administrator to determine which storage format is suitable for your firm.

Moving data locations

You can move data locations depending on which data storage format is selected—either a Standard file format or Microsoft SQL Server format—when the data location is added in FileCabinet CS.

See also: Copying drawers between data locations

Backing up data locations

As a best practice, we recommend that you create and retain regular backups of your SQL Server database. If you create data locations with the SQL data format option, you can schedule recurring backups of the entire database, or you can manually perform individual backups of your FileCabinet CS Drawers.

For more information, see Backing up and restoring FileCabinet CS SQL data locations.

You can create backups of individual drawer data for data locations that are created in either the Standard format or SQL database format. For more information, see Backing up drawer data.

Restoring data locations

The type of backup created—either a Standard file format or Microsoft SQL Server format—determines the option that you choose in the Restore dialog.

Share This