How do I enable automatic database backup?

How do I enable automatic database backup?

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

  1. Go to Tools > Database Backup Scheduler
  2. To turn it on hit the checkmark beside Enable Scheduler.
  3. Select a path to store the database backup.
  4. Set the schedule frequency and time of the backup.

The Database Backup Scheduler automatically backs up the CurrentWare database (CWNPSQL or CWNPFB.CWD depending on your database) at a scheduled time. You can choose between backing up the database on a daily, weekly or monthly basis.

The databases will be backed up into the following default directory: 

Legacy Firebird Database: \Program Files (x86)\CurrentWare\cwServer\Backup\ 
SQL Server Database: \Program Files\Microsoft SQL Server\MSSQL14.MYPROD\MSSQL\Backup

Up to a maximum of 10 databases will be backed up into the folder. It will keep the newest 10 databases and automatically delete the older ones. You can perform a one-time back up by clicking on the “Run Backup Now” button.


    • Related Articles

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

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

    • Free up space from your SQL Express Database

      By default, the CurrentWare install of SQL Express has a 10GB size limit. This means you can store up to 10GB of data on-prem without any changes on your end. CurrentWare will not automatically remove your data. You must manually set up the ...

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

    • My database is getting big. How do I reduce the file size?

      ⚠️IMPORTANT NOTE: Before you begin, back up your existing database file (CWNPSQL) through the Tools > Database Backup Scheduler > Run now. Delete Bandwidth data Bandwidth data takes up a majority of your database. Deleting Bandwidth data will save ...