PC SOFT

FOROS PROFESIONALES
WINDEVWEBDEV y WINDEV Mobile

Inicio → WINDEV 2024 → How to restore differential backup on another machine?
How to restore differential backup on another machine?
Iniciado por guest, 13,mar. 2015 13:33 - 3 respuestas
Publicado el 13,marzo 2015 - 13:33
Hi,

I have a database backup from a customer that i would like to restore on my own computer.
I have :
- the full backup (date 01/03/2015)
- the differential backups until today (backup.hyb files).

All this is stored in a directory structure that looks like \YEAR\MONTH\DAY\etc...

I am using the hyperfile control center version 19. I have used the 'Restaurer une sauvegarde' -> 'depuis un répertoire' menu on the 'Backups' tab. There I had to specify the directory containing the 'backup.info' file. This file is situated in the same directory as the full backup (dating from 01/03/2015). Now it seems that only the full backup is restored.

How can i restore the backup.hyb files in the control center:confused:

Thanks for helping me.
Joris.
Publicado el 17,marzo 2015 - 13:22
Hi,

I am actually wondering if there is anyone using these differential backups.
Please let me know.

Regards,

Joris.
Publicado el 17,marzo 2015 - 17:40
Hi Joris, while differential backups are there and for sure have their useful use cases, everybody who chooses a differential backup has to know that a single hardware failure on any of these media with much smaller backups will impede a full restore! For a HFSQL database I recommend to do a daily full hot backup somewhen at midnight or later. HFSQL can do its full backup without stopping the database! Of course, there's always the question onto which media the backup should finally go if a database is bigger than 4,5 Gb. First, there is a way to compress the files using 7z which is the strongest compression available, so maybe, a 10gb+ database can be saved to a single DVD. If the database is bigger than that, there are blurays or tape drives.
Publicado el 18,marzo 2015 - 12:03
Hi Guenter,

Thank you for sharing your ideas.
I never use differential backups to be honest.
Unfortunately, when scheduling a backup in the control center, the differential backup is proposed by default... and then there is murphy's law :rolleyes:....

Regards,
Joris.