Create a fresh database

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 settings, there are several benefits of starting a fresh database:

No legacy data: A fresh database has no legacy data to deal with and maintain.

Improved data integrity: Starting with a clean slate allows you to enforce data integrity and consistency from the beginning, ensuring accurate data representation.

Better performance: Without legacy data and constraints, a fresh database can be optimized for performance, leading to faster query times and reduced load on the system.

Cost savings: Starting a fresh database is less expensive than upgrading to a SQL standard license.

Troubleshooting: By creating a new database, you can confirm if you are having any permission related issues with logon accounts.

How to create a fresh database

  1. From your server PC run a windows search for “cwsm.exe” or go to C:\program files(x86)\CurrentWare\cwServer\ and run the “cwsm.exe” application.
  2. Go to the “Database” tab
  3. Go to the section labeled “SQL Database Name“.
  4. Press the “Edit” button.
  5. Change the name to “CWNPSQL1“.
  6. This will recreate a database connection and prompt you to enter an operator user name and password
  7. The new database is created and you can now log in to your console running a fresh database.


    • Related Articles

    • Move the CurrentWare server to another computer with network SQL database

      When moving your CurrentWare software to a new server/PC you need to make sure you do not have both consoles connecting to the same networked database. Here are the steps to take. #1 Back up your existing cwServer Database Before you migrate your ...

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

    • How to recover your CurrentWare Console password

      During the CurrentWare installation or upgrade process you are prompted to create an operator account and password. The user information is encrypted and stored on your local database. If you have forgotten your account information the CurrentWare ...

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

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