Database Maintenance
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 ...
Change the CurrentWare Database Backup Location
Using the CurrentWare application to backup only gives you the option to use the default SQL folder backup location. The backup must be in the default folder for SQL to recognize it. This page will help you change the location for the backups. To use ...
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 ...
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 ...
What is DB caching in CWSM?
The button to clear Database Cache is a best practice query that will run on your CurrentWare SQL Database to improve performance of table load times within your CurrentWare Console. It will run the “exec sp_updatestats” command which is used to ...
Can CurrentWare delete older data automatically?
Yes, you can set up CurrentWare to automatically delete older data such as URLs, applications, bandwidth, and device data. If you are running the default SQL Express setup, there is a 10 GB limit on data. An optimized database will improve the ...