How do I Backup and Restore the CurrentWare Database

How do I Backup and Restore the CurrentWare Database

It is important to back up your CurrentWare 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. Database Backup Scheduler

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

  1. Go to 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.

2. Manual Backup

You can manually copy the live database file on the CurrentWare Server computer.

  1. Go to the following path where the database is stored:
    C:\Program Files (x86)\CurrentWare\cwServer\
  2. Find the database file named CWNPFB.CWD and copy the file to a backup location of your choice.

3. Archive Database

Archiving the CurrentWare 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.

Restoring the CurrentWare Database

1. Using the CWSM

The procedure to restore the CurrentWare database depends on your back up method.
If you used the CurrentWare Server Manager to back up 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

2. Manual Restore

If you used a backup scheduler or did a manual back up of the database, you can replace the live database with your back up.

  1. Turn off CurrentWare Server Services
  2. Turn off Firebird Services
  3. Rename your backed up database to CWNPFB.CWD
  4. Replace the C:\Program Files (x86)\CurrentWare\cwServer\CWNPFB.CWD with your back up
  5. Start the CurrentWare Console or CurrentWare Server Services again.

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