Loading...

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.
  • Only SQL server authentication credentials with sysadmin role is supported. Windows authentication for SQL user credentials is not supported.
  • The SQL instance collation and the SQL database collection must match.

Before You Begin

  1. Install Java Runtime Environment (JRE) on the destination client.
  2. Verify that the path where you installed Java is defined in the Windows default PATH environment variable.

Procedure

  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. Type the SQL server login credentials for the source SQL instance.
    3. Click Add Target Table.

      The Archiving Configuration wizard appears.

    4. From the Select Archiving Target Table section, select a schema and an archiving target table.
    5. From the Add Related Table Options section, select the options that you want to use for archiving table.
    6. Click Next.
    7. 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.
    8. Click Finish.

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

    9. In the Archiving Tables box, right-click a table, and then select Specify Archive Criteria.
    10. 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.

    Notes:

    • 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: 9/6/2019 1:07:14 PM