Creating a SQL Database Archive Subclient

Create a SQL Database archive subclient.

Note the following caveats when you archive SQL Server database tables:

  • Database names containing characters {, }, and ; are not supported for archiving.
  • Table names containing characters [, ], and . are not supported for archiving.
  • Read-only databases are not supported for archiving.
  • You can archive only one target table for each subclient.
  • The domain impersonate user account that you used for the backup and restore is used for archiving.
  • The SQL instance collation and the SQL system databases collation must match.
  • Archiving is not supported for databases that use the Always Encrypted format.
  • Columns of data type 'geography' or 'geometry' are not archived and skipped because bulk copy is not supported for these data types.


  1. From the CommCell Browser, expand Client Computers > client > SQL Server.
  2. Right-click the instance, and then click New Archive Subclient.

    The Creating New Archive Subclient dialog box is displayed.

  3. In the Subclient box, type a name for the subclient that you are creating.
  4. On the Content tab, provide the information for the source database table that you want to archive:
    1. From the Database list, select the SQL database that you want to archive.
    2. Click Add Target Table.

      The Archiving Configuration wizard appears.

    3. From the Select Archiving Target Table section, select a schema and an archiving target table.
    4. From the Add Related Table Options section, select the options that you want to use for archiving table.
    5. Click Next.
    6. Optional: Review the database table and its child tables (if any) that you are associating with this subclient. If you do not want to archive the child tables, then clear their check boxes.
    7. Click Finish.

      The database table that you associated with the subclient is displayed in the Archiving Tables box.

    8. In the Archiving Tables box, right-click a table, and then select Specify Archive Criteria.
    9. To provide a SQL query for the archive job, select the table name from the Table Name list, and then select columns and operators for the query.

      You can also manually type the SQL query.


    • SELECT, FROM, and WHERE tags are implied. Only provide the query after WHERE.
    • If you do not provide a query here, all data from the tables is archived because the default criterion is set as 1=1.
    • To prune archived rows from the tables, select the Delete Rows check box.
  5. On the Archive Options tab, provide the information for the destination database where you want to export the archived data:
    1. Select the SQL client, the instance, and the database to which you want to export the archived data.
    2. Type the login credentials for the destination SQL instance.
    3. To create a view of the archived data and the active data on the source database, select the Create uniform view for Active and Archive Data check box.
    4. To stage data, in the Path For Archive Data Files box, type or browse to a folder path on the destination client. This staged data is then exported.
  6. On the Storage Device tab, in the Storage Policy list, select a storage policy name.
  7. Click OK.

Last modified: 10/8/2020 5:54:21 PM