remote Database Backup

Hi,

I need the users to be responsible for their data backup.
The Database is on a remote server and I would like to give the users the possibility to backup their data on their local PC.

Is there a way to do this?


Thanks
Noel

Hello Noel

If the user makes an rdp connection to the server and enables access to their drive or local network you can use the Windev Zip functions to write a zip file back to their local drive / network.

Regards
Al

Hi,

a HFSQL server can be instructed (by using the HF Control Center) to regularily perform a hot backup. "Hot" means that there is no necessity to stop all clients or cease doing any work. Those backups can then be copied to the client's hard disk.

Second way is to use the HF Control Center to "convert" the server data to a local HF Classic database. This will work only if you're using .fic file extensions in your analysis.

Kind regards,
Guenter Predl
office@windev.at

Hi Al , Guenter

rdp and any other connection is out of the question from their IT department.


ideally it would be along the lines of :



Backup_Doc is hBackupDescription
Backup_Doc..Description = "Roster Backup"
Backup_Doc..WithIndex = True
Backup_Doc..Destination = EDT_Directory
Backup_Doc..Source = COMBO_Database..DisplayedValue
Backup_Doc..Compression=zipFormatZIP
// Backup_Doc..ProgressBar = "PROGBAR_Main"
Backup_Doc..Description = EDT_Comment


nID = HBackup(gctMasterDatabaseConnections, Backup_Doc)


but works for a remote connection.

This is meant for challenged computer users

Thanks



Edited 1 time(s). Last edit at 07/07/2021 09:28AM by ntnati.

In order to make a local copy of a CS DB, you can use the hcopyfile instruction, with the syntax to copy locally, BUT, as you are working on each file individually, you are not going to get a DB with full integrity (users can add things in files while you are copying each file individually)

So, in order to get a 'good' db, you would need to stop all users access during that time... or you don't care :-)

Hi all

the solution I will be implementing is the this:

using the below code

Backup_Doc is hBackupDescription
Backup_Doc..Description = "XXXXX Backup"
Backup_Doc..WithIndex = True
Backup_Doc..Destination = "ServerDirectory"
Backup_Doc..Source = DatabaseToBeBackedup
Backup_Doc..Compression=zipFormatZIP
Backup_Doc..Description = "any comment by the user"
nID = HBackup(gctMasterDatabaseConnections, Backup_Doc)


using the nID I will FTP down to the user PC.

Thank you all for your help

Copying backup to the user's pc can pose some security problems, the user can restore it in any other environment and have full access to all the data.
It depends on the content of the database but if there are personal data of EU citizens in the database it can even have legal implications (GDPR).

Regards

Paulo Oliveira

Hi Paulo,

yes, indeed! But.there has to be a responsible admin who is able to restore the database if the bad boys from Russia encrypt the server's disk content. In order to be able to do so, he should have a most recent backup at hands, burnt onto a DVD or BlueRay disk. So, of course, not every user should be allowed to copy backups to his/her PC but there should be a group of admins who are able to do exactly that. Every company by law has a data protection officer who is responsible for the correct handling of these files.

Kind regards,
Guenter Predl
office@windev.at

Yes you are both right on all counts.

The possibility of doing the backup will depend on the login (most likely the IT person) and zip file will be password protected. Restore will then be done by us because, at that stage the server would have developed severe problems.

The whole problem arose when a couple of days ago we discovered that the scheduled backup failed and therefore we would like to shift the responsibility from us to somebody else.

regards
noel