Database Tools
Optimize Database
Overview
The Optimize Database tool removes and/or repairs various records within the database. It is NOT recommended to run this tool frequently.
Warning - Before running any optimization tool, please backup your database to protect against data loss.
Running the Optimize Database Tool
To run the Optimize Database tool:
- Click the system menu button ( ) > Administration > Optimize Database.
- Select Optimize Database.
- Configure the following options:
- Remove notifications and expired announcements - Removes notifications and expired announcements from the database.
- Remove Smart Publishing information - Removes all cache information used to intelligently decide when a published file needs to be re-transmitted to the destination server.
- Remove old versions of assets - Removes all but the current version for all version-capable assets from the database. This includes: pages, files, blocks, formats, templates and external links.
- Remove orphaned records - Removes all child records from the database that are no longer referenced by a parent record (e.g. blobs, metadata, page configurations, page regions, etc.).
- Remove Background Task History - Removes all background task history items before the selected start date/time.
- Click Submit.