How do I Backup and Restore my CurrentWare Firebird Database?

It is important to back up your CurrentWare Firebird 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

From your CurrentWare console, you can configure CurrentWare to backup 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.
  4. Select the Apply button at the bottom of the page.
  5. Your Database Backup Scheduler is now scheduled to automatically backup.
  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 (Firebird Only).

  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

There are two ways to restore your Firebird Database back onto your CurrentWare server. You can either user the CurrentWare Server Manager(CWSM) or manually restore the Database file.

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 backup 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 backup 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!