CurrentWare Database Maintenance

When your CurrentWare database reaches 1GB, the performance of your CurrentWare Console will become slower.

To optimize the performance of your CurrentWare Console, we recommend deleting some old data and compressing your database.

Before you begin, please back up your existing database file (CWNPFB.CWD) to another location

#1 – Delete data before a specific date

Use the Delete URLs option to delete URLs from your database before a specific date.

After the URLs have been deleted, you will need to compress the database.

Launch the CurrentWare Server manager from Start menu > All Programs > CurrentWare > CurrentWare Server Manager. Click on the Compress tab.

Browse to the CWNPFB.cwd file inside \Program Files\CurrentWare\cwServer and click on the Compress button. The database will be compressed to reduce file size.

#2 Enable the Auto Delete URL Scheduler to clean up your database periodically

Go to Tools > Auto Delete URL Scheduler. Enable this option to clean up your database automatically. When enabled, BrowseReporter will only keep data from a period of time that. You can define how long you want to keep data for.

#3 Enable the Database Backup Scheduler

Go to Tools > Database Backup Scheduler. Enable this option to begin automatically backing up the CurrentWare database on a daily, weekly or monthly basis.