Purge Database
Purging is the process of freeing up space in the database or deleting obsolete data that is no longer required. The purge process can be based on the age of the data or the type of data.
...
- Make sure you are on the Site Properties tab. Within the grid, in the Is Purge column, select the checkbox(es) for the site(s) for which you want to purge database.
- Switch to the Replication Tasks tab under Views -1 to define the number of days to apply purging and PK Purge Query:
- In the Data Purged After Days column, enter the number days starting from today for purging to be applied.
- In the PK Purge Query column, double-click the cell where a purge query is to be added. When the Browse button appears, click it to open the SQL Editor dialog:
In the SQL Editor dialog, enter the SQL query or click Load to define the directory to the statement. Click Save to... to specify the save directory on your computer or Save&Close to apply the changes in the editor.
...