How to BackUp and Restore Qlik NPrinting Repository Database from End to End

Frank_S — Thu, 13 Mar 2025 19:26:00 GMT

! Note: Do NOT modify the NPrinting Database for any reason using PG Admin postres query or any other execution tools as this will damage your NPrinting Deployment and prevent successful NPrinting Database backup and restore operations.

! Note: Do NOT restore an older version of an NPrinting Database to a New NPrinting server or restore a newer version of the NPrinting database to an older version of NPrinting Server.

Examples:

NP 21.0.0.0 to NP 21.0.0.0 This is OK
NP 20.29.7.0 to NP 20.39.6.0 NOT OK This will compromise your deployment of NPrinting
NP 20.39.6.0 to NP 20.29.7.0 NOT OK This will compromise your deployment of NPrinting

These rules apply to general releases and service releases: The point version of the NPrinting Database being restored must match the point version of NPrinting Server being restored to (see Backup and restore Qlik NPrinting).

How to Identify an incorrectly/unnecessarily restored database: Identify NPrinting Server restored with incorrect NPrinting database version

! Note: From NPrinting February 2020 and later versions, it is NOT necessary to enter a superuser database password

! Note: If you are making a backup for the Qlik Support team, please add the following NPrinting user information so that we can log onto the NPrinting Web Console following the local restore of the database (also ensure that NPrinting Authentication is enabled. Go to Admin > Settings > Authentication

user: npadmin@qlik.com
password: npadmin@qlik.com
NP Role: Administrator

This procedure is meant to backup and restore (partial backup and restore of these individual items is not possible*):

NP Web Console Items:

NPrinting apps
Tasks
Connections
Filters
Schedules
*Reports (can separately be exportable/importable however only and exclusively between identical versions of NPrinting. See Related Content section link below)
Conditions and most settings applied to an existing system

NP Backup zip File Contents (do NOT open and modify the contents of this file):

A dump of the NPrinting database repository
All files used by report templates
All files related to reports published on the NewsStand
All files related to On Demand reports
The backup file size can be 'roughly' estimated by enumerating the size of the folder "c:\programdata\nprinting\apps"

NOTE: Settings that are not backed up or restored are documented below.

Resolution:

NOTE:

Do not unzip the backup file (np_backup.zip), simply copy it toc:\nprintingbackups

Before Proceeding: Please log on as the NPrinting service account used to run the NPrinting Web Engine and Scheduler services before proceeding

The video below makes no mention of the Qlik NPrinting License Service which was included on newer versions. It also needs to be stopped as documented below.
If restoring to a different NPrinting server environment, see step 7 below for additional consideration not covered in the video below.

1. Stop only the following Qlik NPrinting services (do NOT stop any other services)

Open the Windows Service Manager (services.msc), and stop the following services (by right-clicking them, and then clicking Stop). This will ensure any manual or scheduled NPrinting Publish Tasks are not executed during the backup or restore process:

Qlik NPrinting Engine Service (NOTE: Stop all NP Engines connected to your NP server before proceeding)
Qlik NPrinting Scheduler Service
Qlik NPrinting WebEngine Service
Qlik NPrinting Audit Service
Qlik NPrinting License Service

2. Create a folder for the backup in:

C:\NPrintingBackups

3. Open Command prompt and change directory path

Do NOT modify any syntax or add any additional unnecessary spaces
Open the command prompt making sure to run cmd.exe as Administrator and change directory as follows:

cd C:\Program Files\NPrintingServer\Tools\Manager

4. Backup

Copy and paste the following backup syntax to the command prompt console. Replace superuserDBpassword with your password first used when installing NPrinting.

Qlik.Nprinting.Manager.exe backup -f C:\NPrintingBackups\NP_Backup.zip -p "C:\Program Files\NPrintingServer\pgsql\bin" --pg-password YourSuperuserDBpasswordHere

or with Current Supported versions of NPrinting (no password required)

Qlik.Nprinting.Manager.exe backup -f C:\NPrintingBackups\NP_Backup.zip -p "C:\Program Files\NPrintingServer\pgsql\bin"

5. Restore

Copy and paste the following backup syntax to the command prompt console. Replace superuserDBpassword with your password first used when installing NPrinting.

Qlik.Nprinting.Manager.exe restore -f C:\NPrintingBackups\NP_Backup.zip -p "C:\Program Files\NPrintingServer\pgsql\bin" --pg-password YourSuperuserDBpasswordHere

or with Current Supported versions of NPrinting (no password required)

Qlik.Nprinting.Manager.exe restore -f C:\NPrintingBackups\NP_Backup.zip -p "C:\Program Files\NPrintingServer\pgsql\bin"

Keep in mind: You may safely ignore any restore 'error' messages found in the nprinting_manager.log file as seen below.

File C:\Users\domainuser\AppData\Local\Temp\2\nprintingrestore_20201203082300\files\xxxxxxxxxxxxxxxxxxxxxxxxxxxx does not exist in the source backup package.

These are references to NPrinting Apps/Connections/Reports that once existed and have been subsequently deleted from the NPrinting Web Console.
For example, A report/connection/NP App may have been deemed retired, then manually deleted by a user with appropriate NP role permissions since it no longer served any specific purpose.

6. Start all NPrinting server services that were stopped earlier.

Restoring to a Different Environment

! Note: If re-installing on existing or restoring to a different NPrinting server environment, ensure that the destination NPrinting server license is enabled/activated before restoring the NP database.

If restoring to a different NPrinting server environment (same NP database version as the NP server version that you have restored to),

Note that once the restore to the Target/Destination server is complete you will need to update the following applicable settings in the NP Web Console on the Target/destination server that the NP database has been restored to:

NPrinting Engine:

Sept 2019 and earlier NPrinting versions: Update the NP Engine in the Engine Manager via the NPrinting Web Console. Add the name of the new NP Engine Computer name here and disable or delete the original NP Engine entry.
November 2019 and later versions, you will need to follow the Resend Certificate section of the following article New Engine Certificate Installation Process and Resolving NP Engine Offline in order to resend the NPrinting Engine certificates

NP Connections:

QlikView NP Connection paths if local QVW or QVP connection paths have changed
Sense connections: if the Sense IDs, Proxy address and NP Identity (NP service account used on the target NP server) has changed at the time of the NP database restore

Qlik Sense Certificates (if using NPrinting Qlik Sense connections)

April 2019 and earlier NPrinting versions: you will need to re-import the Qlik Sense certificates to the new NPrinting server
If June 2019 and later NPrinting versions: you may simply copy the previously exported client.pfx file to the following folder and Restart all NPrinting server services
C:\Program Files\NPrintingServer\Settings\SenseCertificates
- How to Connect NPrinting to Single or Multiple Qlik Sense servers (NP June 2019 and later versions only)
NPrinting May 2023 and Newer: If working exclusively with May 2023 and later NPrinting versions, use this certificates help page: https://help.qlik.com/en-US/nprinting/Content/NPrinting/DeployingQVNprinting/NPrinting-with-Sense.htm

Re: How to BackUp and Restore Qlik NPrinting Repository Database from End to End

PabloLabbeImaps — Thu, 20 Jun 2024 00:46:44 GMT

From NPrinting February 2020 and later versions the requirement to not restore an older backup on a environment with newest version still apply ?

Re: How to BackUp and Restore Qlik NPrinting Repository Database from End to End

Sonja_Bauernfeind — Fri, 28 Jun 2024 06:16:29 GMT

Hello @PabloLabbeImaps

We confirm that this is still the case.

Re: How to BackUp and Restore Qlik NPrinting Repository Database from End to End

PabloLabbeImaps — Mon, 01 Jul 2024 12:14:13 GMT

Thank you for confirm that.

article How to BackUp and Restore Qlik NPrinting Repository Database from End to End in Official Support Articles

How to BackUp and Restore Qlik NPrinting Repository Database from End to End

Resolution:

1. Stop only the following Qlik NPrinting services (do NOT stop any other services)

2. Create a folder for the backup in:

3. Open Command prompt and change directory path

4. Backup

Copy and paste the following backup syntax to the command prompt console. Replace superuserDBpassword with your password first used when installing NPrinting.

6. Start all NPrinting server services that were stopped earlier.

Restoring to a Different Environment

If restoring to a different NPrinting server environment (same NP database version as the NP server version that you have restored to),

Note that once the restore to the Target/Destination server is complete you will need to update the following applicable settings in the NP Web Console on the Target/destination server that the NP database has been restored to:

Related Content:

Re: How to BackUp and Restore Qlik NPrinting Repository Database from End to End

Re: How to BackUp and Restore Qlik NPrinting Repository Database from End to End

Re: How to BackUp and Restore Qlik NPrinting Repository Database from End to End