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 ...

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

• Create a fresh database

  By default, CurrentWare comes with SQL Express pre-installed, which has a 10 GB data limit. To avoid reaching this limit and still keep your historical data intact, you can opt to create a fresh database. Although you may have to reconfigure previous ...

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