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 ...
    • System Requirements

      CurrentWare is designed to work seamlessly with a wide range of computers running Windows operating systems, including both 32-bit and 64-bit platforms. The Web Console offers exceptional versatility, as it can be accessed from any browser and any ...
    • How do I connect CurrentWare to my SQL Server?

      From your CurrentWare Server, go to C:\Program Files (x86)\CurrentWare\cwServer\ In this folder you can run the CWSM.exe file. This will bring up the CurrentWare Server Manager. Select Database > Selection > SQL Server. Enter your SQL Server details: ...