topic Re: Merging backup file in Management & Governance

Merging backup file

thedoge1 — Mon, 03 May 2021 14:38:23 GMT

Hello,

I wanted to see if it is possible to merge an older .dmp file with the current database. I have a site that a setting had been changed and the data started being truncated. I have an older backup file (.dmp) that contains some of the lost data and I would like to add or merge the data from the older backup file with the current database. Is this possible?

Thanks

Re: Merging backup file

Bastien_Laugiero — Mon, 03 May 2021 14:51:36 GMT

Hello!

As far as I know this is not possible nor supported.

You could in theory restore both databases and then run some sort of compare to update the target one but my biggest concern is that you will run into problem with duplicated keys for example.

When you say "Data started being truncated" which type of data are you referring to?

Re: Merging backup file

thedoge1 — Mon, 03 May 2021 16:12:32 GMT

Qlik is being used by a Video Analytics application that we have installed at the customer site. The data being stored is info such as number of people who crossed a line, number of people who stayed within a certain area for a specified amount of time, type of object such as vehicle, bicycle, person and facial recognition.

Re: Merging backup file

Bastien_Laugiero — Tue, 04 May 2021 08:19:10 GMT

Thank you for the feedback!

Not sure exactly how this is setup but it sounds like you are missing data in your Qlik Sense Application(s).

In that case, if you have a backup of the application stored in \\Server\QlikShare\Apps, a restore of this file may be enough.

Hope this helps!

Re: Merging backup file

thedoge1 — Tue, 04 May 2021 13:52:23 GMT

The problem is that the current backups only go back for a week. I do have
one backup from 2/11/21 that was done before the manufacturer did some work
on the system. My data currently goes back to only 3/1/21. If I could
merge the 2/11 backup into the current database that would give me some of
the data back and I would only be missing the data between 2/11 and 3/1

Re: Merging backup file

Bastien_Laugiero — Tue, 04 May 2021 14:01:27 GMT

Thanks for the feedback!
When you say "backup", do you mean backup of the Qlik Sense Application?