There are four database maintenance procedures. Only NeXpose global administrator can perform these tasks. access the controls for these procedures by clicking the Maintenance link on the Administration page.
- Clean up the database, and remove leftover data from deleted sites and assets.
- Compress database tables, and reclaim unused, allocated space.
- Reindex the database by dropping and recreating the database indexes for improved performance.
- Create a backup archive of the current database.
It is a best practice to perform these procedures at least monthly.
Performing database maintenance
You can initiate several maintenance operations to maximize database performance and drive space.
Go to the NeXpose Maintenance Mode—NeXpose DB Maintenance page.
Click the check box labeled Clean up Database to remove leftover data that is associated with deleted objects such as sites, assets, or users.
Click the check box labeled Compress Database tables to free up unused table space.
Click the check box labeled Reindex Database to rebuild indexes that may have become fragmented or corrupted over time.
After selecting the desired maintenance operations, click the button labeled Start Database Maintenance. NeXpose will perform the operations the next time it starts.