Manage system backups

As with any application, it is important to ensure that backups are performed regularly. PaperCut NG/MF includes a built-in database export that saves the state of the database to a file. This functionality is designed to complement (not replace) a good system-wide backup process. The export is stored in the industry standard XML format and compressed using the standard ZIP format to reduce disk-space on the server and your backup medium. The use of these open standards ensures that your data is always available and accessible.

As PaperCut NG/MF is centrally managed, the only database that requires backup is on the Application Server. Secondary print servers and Site Servers do not require a database backup.

PaperCut NG/MF makes the process of managing export backups simple by automatically performing a weekly export. Export backup files are placed in the following directory:

[app-path]\server\data\backups

The weekly exports are performed at 20 minutes past midnight on Sunday morning (or as otherwise defined by the schedule.weekly config key. See Using the Advanced Config Editor to find out how to change config keys.)

Performing an online backup

In addition to the automated weekly exports, it is also possible to manually initiate a database export. This might be useful to back up the system database before performing an upgrade. To perform a manual export:

1. Select Options > Backups.

   The Backups page is displayed.

2. Click Export Now.

   A window is displayed showing the export progress and the location where the export file is saved.

Restoring an export backup

There are a number of situations when it might be necessary to restore a database, including:

• Hardware or system failure requires you to rebuild the server and reinstall PaperCut NG/MF.
• A new print server was purchased and PaperCut NG/MF is being moved to a new server.
• To import data into an external RDBMS (See Deployment on an external database (RDBMS)).

To restore from an export file:

1. Locate a previous export file.
2. Shutdown the Application Server (See Stop and start the Application Server). The database cannot be in-use when performing the restore, so the Application Server needs to be stopped first.
3. Open a command prompt. On Windows 7 and Server 2008 systems, this might need to be specifically elevated to run with administrator privileges, even if you are already logged in with an administrator account. Change to the server binaries directory. On a Windows system the directory location is [app-path]\server\bin\win\.
   TIPYou must run the command prompt as an Administrator. In the Windows Start menu, right-click Command Prompt; then select Run as administrator.

4. Re-initialize the database back to an empty state by typing the following:

   db-tools init-db -f

5. Run the import process by executing the following:

   db-tools import-db -f “C:\path\to\backup\backup-file-name.zip”

   (Or, ./db-tools on some systems. See Database tool (db-tools) for more information on using db-tools) NOTE: On Mac/Linux ensure proper permissions for access to the file, e.g.

   chown papercut:admin \path\to\backup\backup-file-name.zip

6. The import asks if the existing database data should be deleted before proceeding.
7. Once the import has completed, restart the Application Server (See Stop and start the Application Server).

Performing an offline backup

Performing an online backup (as discussed above) is a simple and convenient process, but it is sometimes necessary to perform a backup when the Application Server is not running. For example:

• To integrate into your existing backup procedures, it might be necessary to write a script or batch file to perform a backup at a known point in time.
• When it is necessary to guarantee that the backup captures all the data. Performing an online export while the system is in use can modify data after the export is complete.

To perform an offline backup:

1. Stop the Applcation Server (See Stop and start the Application Server). To ensure all data is captured, the Application Server must be stopped to perform an offline backup.
2. Open a command prompt. On a Windows system change to the following directory: [app-path]\server\bin\win\
3. Run the database export process by executing:

   db-tools export-db

   (This create an export file in the system backups directory and the filename named with a timestamp).

   The export command has additional options that allows you to specify a different directory or filename. See export-db Command for more details.

Export file retention

Export files in

[app-path]\server\data\backups

are retained for 30 days and then deleted. You can change the number of days on the Options > Backups page under “Keep exports for … days”. This period is automatically extended should exports not be performed on a regular basis, i.e. when automatic exports have been temporarily disabled for a time or when skipping scheduled exports due to a system outage. Older export files are not deleted unless a number of new exports have been performed. At the very least the latest export file is always retained regardless of its age.

Backup print archive files

By default the print archive is stored in

It is not included in the database exports detailed above. It is recommended that you consider backing up part or all of the print archive with your existing backup processes. As PaperCut is resilient to partial restoration of the Print Archive you might want to backup only a month or two worth of archives. There is a README.txt in the archive directory that explains more about partial backups and the directory structure layout.

Backup the Print Deploy configuration

The files created and used for Print Deploy are not included in the nightly PaperCut NG/MF backups. You need to set up your own back up procedure for the Print Deploy configuration files. You need to back up the following files:

Windows Application server

<install path>\providers\print-deploy\win\data\

Mac Application server

<install path>\providers\print-deploy\mac\data\