Diese Seite mit anderen teilen ...

Informationen zum Thema:
Forum:
WinDev Forum
Beiträge im Thema:
15
Erster Beitrag:
vor 2 Jahren, 11 Monaten
Letzter Beitrag:
vor 1 Jahr, 11 Monaten
Beteiligte Autoren:
Joris, Steven Sitas, Allard, StanleyBarnett, Michael Drechsel, GuenterP, Sead Grbesic, DerekM

[WX19] How to restore differential backup on another machine?

Startbeitrag von Joris am 13.03.2015 12: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.

Antworten:

Hi,

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

Regards,

Joris.

von Joris - am 17.03.2015 12:22
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.

von GuenterP - am 17.03.2015 16:40
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.

von Joris - am 18.03.2015 11:03
Hi Predl and the others,

I have one question related to this topic. In network environment I use daily Scheduled backup on server using HFSQL Control Center. Everything is ok when destination of the backup is on the server. But, when I use some folder (shared before) on one of workstations, backup does not start and I get a message that access is denied. In the same time copy / paste jobs between these folders (on server and workstation) works without any problem.
If you or any other have some experience with this "problem" (firewalls, antivirus etc.) it would save me time.

Best regards,

Sead Grbesic

von Sead Grbesic - am 15.05.2015 16:20
Hi Sead,

the HF SQL Backup runs with system privileges and maybe this is the reason why copy/paste with your account privileges works and backup not.

von Michael Drechsel - am 16.05.2015 08:18
Hi Sead Grbesic

If you read the documentation on the control centre it is stated that network drives are not supported.

I had this problem and othe issues as well. So my answer is to make your own backup system!!!!

You then will be able to backup of whole hyperfile cs or just one db / specify where you want to backup etc. ( for instance usb stick )
It is verry easy to do this all. It took me about 1 day to complete everything. ( It is just a view lines of code !! )I made it so that one can make a hot backup in the app and when the app closes one will be promted to make a backup , or leave the programm without making a backup.

It is verry important to make backups not just ones a day.I deally is when the app makes the backup, for instance when clossing the app.
But that is my opinion. An Opinion I got after backups with hyperfile cs didnot work properly

regards
Allard

von Allard - am 22.05.2015 08:17
Hi Joris

I'm not sure that no-one actually answered your question.

I have the same issue. I need to get one data row that was backed up incrementally one day after the full backup.

Were you able to restore the full backup *and* the incremental backup?

Regards
Derek

von DerekM - am 08.03.2016 04:57
Hi,

Yes Derek, the question remains unanswered...

Allard,
>> An Opinion I got after backups with hyperfile cs didnot work properly
Please be more specific as to why it does not work properly.

>> network drives are not supported and So my answer is to make your own backup system!!!!
You have to be kidding... So, how do you create a backup system if network drives are not supported? After dealing with the Ransomware crypto issues a few years ago, we consider backups to the same machine as well as backups to mapped drives very weak and do not provide protection to the Ransomware applications. Since then, we created a specific "backup server" that sits on the network with no mapped drives pointing to it. When a computer or app creates a backup or copies files to it for safe keeping to it, it does so via uncs created on the fly and deleted on the fly.

So if any machine gets infected, it cannot find its way to the backup machine therefore protecting your backups from encryption. If the backup files resided on the same machine under a drive letter, then they could easily be encrypted by the virus. Same goes for any mapped drives,even cloud based drives that are mapped.

My 2cents worth from experience,
Stanley

von StanleyBarnett - am 09.03.2016 05:13
Hi Stanley,
I have been doing the same with ftp (instead of on the fly uncs).
Can you share your code that creates and deletes unc on the fly?

Steven Sitas

von Steven Sitas - am 09.03.2016 07:54
Hi stanlyn


>> An Opinion I got after backups with hyperfile cs didnot work properly
Please be more specific as to why it does not work properly.

Ok let me explain what heaapend . The sceduled backup in hyperf cs didnot work. It just didnot do. This resulted in a big problem for My client had no back ups at all for a month. He blamed me and I had to fix the problem. Stating form an old backup!!

Why I donnot know whay but it just didnot work.!!

so making backup functionality in your app makes good sence for me!!. Every time the app is closed user is propted to make a backup. He can choose not to do this but if he doesnot and has a problem then it is his problem not mine.

I am interested in what you say about : a specific "backup server"

I now let clients make a backup to a usb stick. And indeed if they leave the stick then there is a problem. . Could you share how you solved this ??


regards
Allard

von Allard - am 10.03.2016 08:22
Hi Allard,

>> I am interested in what you say about : a specific "backup server"

I can discuss some of this in general while not disclosing the scripts which is used in our commercial solution.

1. Our backup server is a real physical machine that lives in the closet as a headless server. Initially, we tried client operating systems such as XP & Win7 and they proved to be unstable when multiple clients are backing up concurrently. We switched it to Win2008 server and that fixed the thru-put and stability issues.

2. There are no persistant mapped drives going to this server.

3. The on and off-the fly uncs is more of a marketing terminology that actual. All backups are done via unc pathing.

4. After the operation completes, a complete cleanup of registry entries that stores those unc paths and credentials are deleted, so that a rogue and smart application cannot mine the registry for known uncs.

This is about all I can disclose.

A little history, back in 2013 when I got a call from an attorney client that they could not open many of their documents and there was a webpage up with a countdown clock on it with details on how to purchase bitcoins and purchase the keys needed to decrypt their files.

I went in to their office and had a look. Next I started an investigation on how we might recover them and what I learned was nothing short of terrifying.

After bringing the system to our lab for recovery attempts and more research, I went home for the day still thinking about this virus or whatever it was.

Actually, it is NOT a virus, but an app that makes a call to a foreign server and creates a unique public and private key for the infected machine, and then it as quickly as it can starts encrypting files. After the encryption process completes, it displays the ransome page. By the time you see this, your files are encrypted.

I went to bed that night and still thinking about the magnitude of the severity of this and how many mapped drives we used in the office and that they are all vunerable. I immediately got up, when back to the office and deleted all mapped drives on everything and will deal with mapped drive replacements the next day.

And for 3 weeks the race was on to build a solution that protected against this threat and roll something out to our customers.

The end result is to use uncs and connect and disconnect as needed and never use persistant connections. Mapped drives are a no-no also, however we could not get completely away from them as some apps required them. In that case, we build and destroy as needed in a realtime fashion.

Just remember the registry cleanup is very important, as I can easily get a list of previously used uncs from the registry and from there it is as simple as a "net use" command to activate them with a drive letter and start doing damage to the shares files.

Here is more info on the particular issue that my attorney client faced... Note this info has been updated to include fixes and faqs...

http://www.bleepingcomputer.com/virus-removal/cryptolocker-ransomware-information

Thanks, Stanley

von StanleyBarnett - am 17.03.2016 18:08
Hi,

you can also use a commercial Backup Product like Symantec (veritas) backup with a own "backup server".
It works like a client server, every client has an agent installed and push the data to the server over an tcp port.
Runs very fast and has no direct connection to the backup machine.

von Michael Drechsel - am 18.03.2016 11:39
Hi Stanley,
as Michael said, if data is important, a solution like veritas is the only solution.
Please note that your solution - with the registry cleanup - may not be 100% safe.
You could have a "hole" which can be exploited by VSSADMIN.

Somewhere in your shadowStorage maybe there are backups of your registry with all unc data? A virus can search the shadowStorage and find them.

So I would prevent vssadmin to run (through policies) and that way it would also STOP a virus from DELETING your shadow backups. So even if it encrypts your data, you still have clean versions of the data in your shadowStorage.

One thing to remember is stopping VSSADMIN from executing could cause problems with your backup software - so check it first.

There is a small and simple app called CryptoPrevent that automatically takes care of this and other problems. Search for it on google.

Steven Sitas

von Steven Sitas - am 19.03.2016 13:30
Hi again,
something else I forgot to say.
When my scheduled backups don't work it is usually because the server is CLOSED or DOWN at the scheduled time.

You can NEVER trust a user/customer to tell you the truth ....

Steven Sitas

von Steven Sitas - am 19.03.2016 13:34
Zur Information:
MySnip.de hat keinen Einfluss auf die Inhalte der Beiträge. Bitte kontaktieren Sie den Administrator des Forums bei Problemen oder Löschforderungen über die Kontaktseite.
Falls die Kontaktaufnahme mit dem Administrator des Forums fehlschlägt, kontaktieren Sie uns bitte über die in unserem Impressum angegebenen Daten.