My database is getting big. How do I reduce the file size?

My database is getting big. How do I reduce the file size?

⚠️IMPORTANT NOTE: Before you begin, back up your existing database file (CWNPSQL) through the Tools > Database Backup Scheduler > Run now.

Delete Bandwidth data

Bandwidth data takes up a majority of your database. Deleting Bandwidth data will save you the most space. Here are some of the options:

If you are not running Bandwidth reports:

  • Delete all Bandwidth data: this will reduce your database size by more than 50%.
  • Disable Bandwidth Tracking: go to Tracking Options and uncheck “Enable Bandwidth Tracking”

If you are running Bandwidth reports:

  • Delete data before a specific date: delete data to reduce the database file size
  • Decrease Bandwidth data tracking: go to Tracking Options and change the “Discard data less than” value to 10 KB

Delete other data 

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

  1. Open BrowseReporter from the left-hand side.
  2. Choose More options button from the menu bar and select Delete Data.
  3. Choose the checkboxes to delete URLS, Bandwidth and/or Application data.
  4. Choose the PCs or Users.
  5. Select the Period.
  6. Press Delete Data.
    • Note: The deletion of data is permanent.

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

Enable this option to clean up your database automatically. When enabled, BrowseReporter will only keep data for a period of time. You can define how long you want to keep data.

  1. On the CurrentWare Web Console, go to Tools > Auto Delete Scheduler.
  2. Enable the scheduler.
  3. Select the tracked data types you want to delete automatically.
  4. Choose the number of days you want to keep the tracked data for.
  5. Decide on the start time each day to perform the data deletion.
  6. Select to Apply the Auto Delete Scheduler in the bottom-right corner.

Enable the database backup scheduler

Enable this option to begin automatically backing up the CurrentWare database on a daily, weekly or monthly basis.

  1. From your CurrentWare Web Console choose the Tools option
  2. Select Database Backup Scheduler from the menu.
  3. Choose to Enable Scheduler.
  4. Select your Backup Path, Schedule (Daily, Weekly, Monthly) and the Start Time.
  5. Apply the scheduler by hitting the Apply button in the bottom right corner.

    • Related Articles

    • I am not getting any URLs in my reports

      If you are not seeing any URL data in your reports from BrowseReporter, here are some ways to troubleshoot the issue. Restart the Client Computer If you can’t find any URLs in your reports right after installing the client agent on the computer, a ...
    • Release Notes

      Version 10.0.1 June 24, 2024 Quality of Life Release: This update includes performance optimizations, enhancements to the end-user experience, and bug fixes for improved functionality. BrowseReporter - Tracker Optimization: Reduced CPU usage on ...
    • Security & SQL Database Best Practices

      Security and Workflows Connection to the Web Console Starting with v8.0.1, the CurrentWare web console will have a preconfigured self-signed SSL certificate that is enabled by default. This will ensure that network communication to and from the ...
    • I am not getting any Bandwidth activities in my reports

      If you are not seeing any bandwidth data in your reports from BrowseReporter, here are some ways to troubleshoot the issue. Reinstall the Client Agent You may be experiencing issues with user permissions for the client agent on the computer. ...
    • Release Notes - Old

      Return to the list of latest changes Version 5.0.7 June 1, 2016 Fixed a bug with BrowseReporter’s PCs/users selection Fixed a bug with Email Report’s corrupted profiles from previous version Enhanced Web Filtering for Download Filter for Windows 10 ...