Batch file for restoring a backup of NPrinting? Need to run the restore job using Windows Task Scheduler

[jblomqvist]

Hi,

Here in our business project in Sweden we have performed a back up of NPrinting.

We have the zip file. Itbis about 187GB in size.

But it seems like it will take a few hours to do the restore having attempted it from command line.

Is there a batch file that can do the job? The idea being we populate the code in the batch file with the location of the zip file and password and let it run using Windows Task Scheduler.

We can stop and start the services manually but the middle part where the command line is cd to the folder and then restore, we were wondering whether that can be done using  a batch file.

[Ruggero_Piccoli · Accepted solution]

Hi,

You can insert the command you wrote in the Windows shell in a .bat file and then run the batch file. The password of the repository is in the command so it will not ask info interactively. 

In my latest answer to this question https://community.qlik.com/t5/Qlik-NPrinting-Discussions/What-exactly-is-backed-up-when-backing-up-N... I listed all the content of the .zip file generated by the backup procedure. This will help you to evaluate if you have unused stuffs that are keeping the size huge.

Please remember that you can do the restore only on another instance of exactly the same version of Qlik NPrinting. 

Best Regards,

Ruggero

[jblomqvist]

Hi @Ruggero_Piccoli 

Many thanks for replying.

So would the batch file essentially contain only the two commands below?

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

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

And save this in a .bat file format and let the Task Scheduler run it?

I got the commands from this article: https://community.qlik.com/t5/Knowledge-Base/How-to-BackUp-and-Restore-Qlik-NPrinting-Repository-Dat...

We would stop the necessary services first, then let the .bat file run via task scheduler.

Wait for it to finish.

And then start the services as per the URL guide above.

We have ensure the versions of NPrinting are the same 🙂

[Ruggero_Piccoli]

Hi,

In the .bat file you can also insert the commands to stop the services and re- start them after the backup creation. 

See the following example:

net stop "Qlik NPrinting Audit Service"
net stop "Qlik NPrinting Engine" 
net stop "Qlik NPrinting Scheduler"
net stop "Qlik NPrinting Web Engine"
net stop "Qlik NPrinting License Service"
net stop "QlikNPrintingMessagingService"

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

net start "Qlik NPrinting Audit Service"
net start "Qlik NPrinting Engine" 
net start "Qlik NPrinting License Service"
net start "Qlik NPrinting Scheduler"
net start "Qlik NPrinting Web Engine"
net start "QlikNPrintingMessagingService"

 Note that I stop the services in the correct order to avoid interactive questions on the shell. I placed the full path of the .exe instead of the cd so, at the end of the script, the console will still be on the original folder.

You must execute/schedule the script as administrator.

I supply this script only for training reasons and without any warranty ;-).

Best Regards,

Ruggero