You are here: Chapter 10: Database Administration > Database Maintenance > Database Maintenance

Database Maintenance

Selected issues can be completely removed from a FootPrints Project using the Database Maintenance feature.  Specifically, issues that have been changed to the Deleted status are good candidates for archiving since Issues that have spent significant time as Deleted are no longer needed on a regular basis, but can be stored for reference information.  These issues can be stored as read-only in a separate archive Project, which is useful for cleaning up the database by removing obsolete issues from a Project.  Fewer issues in a Project leads to faster searching and reporting times, speeding up database access times.

Important

Make a backup of your FootPrints database before performing any purge function.

Note

This feature is not available in the FootPrints database versions. To get the benefit of this feature, you must upgrade to one of the SQL/ODBC-based versions for Windows (MS SQL Server, Access, etc.) or DBD/DBI-database versions for UNIX/Linux (Oracle, MySQL, Postgres, etc.)

Topics covered in this section include: