You are here: Chapter 10: Database Administration > Database Maintenance > Archiving Data from the Current Project

Archiving Data from the Current Workspace

The archive function removes issues that meet specified search criteria in the source Workspace, copies those issues to the archive Workspace that you specify, and then removes those issues from the Workspace's issue table.

  1. Select Administration | System | Workspaces, then click the GO button in the Database Maintenance section.
  2. Select the Archive option as the Action to Take.
  3. The Status and Date Criteria of Applicable Issues section allows you to define the selection criteria for Archive.  This can be based on either the Issue’s current status, the date it was last edited/created, or a combination of both. 

Tip

Set up an escalation rule that automatically changes the status of closed issues to Deleted for issues that are a certain age.  Then you can skip this step and just use the default highlighted status of Deleted

  1. Type in your password and click GO.
  2. Matching Issues For Archive—All issues that meet the Archive search criteria are listed here and highlighted.  Review the list to ensure you are archiving issues that meet your intended criteria.  You can deselect issues by holding the CTRL key and left clicking the issue with your mouse.  Only highlighted issues are archived.
  3. SQL QueryFootPrints displays the query that was used to retrieve the issues that have met the archive search criteria for your review.
  4. Archive Location—Each “source” Workspace has a designated “destination” archive workspace.  The first time you archive Issues, you must provide a name for the archive Workspace.
  1. Scheduled Run-Time—Archive jobs can be run immediately or at a time when server activity is light (if you have a large job with many issues to archive).
  1. Scheduled Jobs Pending In Current Workspace—This section lists those jobs scheduled to run in the future, as configured in the previous step.
  2. Type in your password and click GO.  Click OK when asked to confirm that you want to complete the archive. FootPrints schedules the archiving to run as a background process based on the time set up in the Scheduled Run-Time step.  This includes jobs scheduled to run immediately.