Free up space from your SQL Express Database

Free up space from your SQL Express Database

By default, the CurrentWare install of SQL Express has a 10GB size limit. This means you can store up to 10GB of data on-prem without any changes on your end. CurrentWare will not automatically remove your data. You must manually set up the auto-delete scheduler to prevent the database from overloading and potentially losing data.

NOTE: Before removing data you should take a backup of your database.

Here are the steps to free space with the Auto-Delete Scheduler:

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 Apply the Auto Delete Scheduler in the bottom-right corner.

There are other database maintenance steps including the ability to manually remove the data here


    • Related Articles

    • How do I Setup CurrentWare with SQL Express

      Welcome to the SQL Express Database Installation and Setup page. Benefits of using a SQL Database with the cwServer are an increase in overall performance and stability of client connections. Here are the steps to download, setup and configure your ...
    • 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 ...
    • Which databases does the CurrentWare Server support?

      The CurrentWare Server is compatible with the following databases: SQL Server Express (default) SQL Server Standard SQL Server Enterprise SQL Server As of v6.0.1, SQL Server is necessary as a database for Currentware. Please see our informative guide ...
    • SQL Server Database and Password FAQS

      This page has some of the most frequently asked questions with how your SQL server interacts with CurrentWare. What is the default SA password for the CurrentWare SQL database? The CurrentWare installer is prepackaged with SQL Express. If you don’t ...
    • Backup and Restore the SQL Database

      It is important to back up your CurrentWare SQL database to ensure that you retain your historical information from CurrentWare’s solutions such as BrowseReporter and AccessPatrol. There are a few ways to back up the CurrentWare database. 1. Backup ...