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 Once

On the CurrentWare console, you can backup your CurrentWare database once manually.

  1. From the CurrentWare Web Console go to Tools > Database Backup Scheduler
  2. Click on “Run Backup Now
  3. The backup database is stored under C:\Program Files\Microsoft SQL Server\MSSQL14.MYPROD\MSSQL\Backup\
  1. Tools > Database Backup Scheduler
  2. Click on “Run Backup Now”

2. Database Backup Scheduler

On the CurrentWare console, you can configure CurrentWare to back up the SQL database periodically.

  1. From the CurrentWare Web Console go to Tools > Database Backup Scheduler
  2. Check the option “Enable Scheduler”
  3. The backup path is set to the default SQL backup directory
  4. Set the frequency – daily, weekly or monthly
  5. Set the time, day or month
  6. Set the start time of the backup job

  1. Tools > Database Backup Scheduler > Enable database backup scheduler
  2. Select a path to store the database backup
  3. Set the frequency and time of the backup

3. Restoring a SQL database using SSMS

  1. Turn off CurrentWare Server Services
  2. Run Microsoft SQL Server Management Studio
  3. Right-click on your CurrentWare SQL database
  4. Select Tasks then Restore
  5. Select the backup set you want to restore then select OK
  6. Start the CurrentWare Console or CurrentWare Server Services again.

4. Archive & Restore Database

Archiving the CurrentWare SQL database will back up the live database and replace the live database with a new one. This optimizes the performance of CurrentWare by reading and writing on a fresh database.

  1. Launch the CurrentWare Server Manager
  2. Type CWSM.exe on the start menu > Launch CWSM.exe
  3. On the CurrentWare Server Manager Database > Archive and Restore > Select Archive

The archived SQL Database will be saved and located in C:\Program Files\Microsoft SQL Server\MSSQL15.SQLEXPRESS\MSSQL\Backup\Archive

5. Restoring an Archived Database

The procedure to restore the CurrentWare database depends on your back up method.
If you used the CurrentWare Server Manager to archive your database, you can restore the archived database from the CurrentWare Server Manager as well.

  1. Launch the CurrentWare Server Manager
  2. Type CWSM.exe on the start menu > Launch CWSM.exe
  3. On the CurrentWare Server ManagerDatabase > Archive and Restore
  4. Select an archived database from the drop-down menu > Select Restore

If you used a backup scheduler, you can use Microsoft SQL Server Management Studio to restore the database


Don't have CurentWare Installed? Download & Get started with a free trial!