2014-10-14 10:01 GMT+03:00 'Marius Labuschagne' mjlabuschagne@... [firebird-support] <firebird-support@yahoogroups.com>:

 

From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: 14 October 2014 08:33 AM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: BLOB

I ran some tests :

A.

"D:\Program Files (x86)\Firebird\Firebird_2_5\bin\gbak.exe" -b -g -v -service xx.xx.xx.14:service_mgr -user sysdba -password masterkey e:\fdb\gestoc_asolo.fdb gestoc_asolo.fbk

B.

"D:\Program Files (x86)\Firebird\Firebird_2_5\bin\fbsvcmgr.exe" xx.xx.xx.14:service_mgr -user sysdba -password masterkey action_backup -dbname e:\fdb\gestoc_asolo.FDB -bkp_file gestoc_asolo.fbk

A. finished in 2 minutes, no visible delay saving table "log_table" . Much much faster than my backup but the FBK file IS ON THE SERVER. I want it on my backup PC (I do this for my clients in case they have a fatal error or they want to restore the database to some previous state) .

B. got a "Feature is not supported" error.

Anyway, I presume that both A and B is about saving the data to a local file on the server. This is not what I want to do.

How do other FireBird users manage this with really large databases ? Save locally and get the FBK file via FTP or some other protocol ?

[Marius Labuschagne]

We make use of Cloud Type Services for example Drop Box or Google Drive.

- Run the backup using a scheduled script file

- Compress the Backup using 7-zip

- Copy the 7-zipped file to the Drop Box folder (which will then sync it to your drop box folder on your machine)

And if you want to take it a step further, you can make use of some form of Grand Parent, Parent, Child methodology and then make use of NBAK, which will make the process much less bandwidth intensive, especially on large databases

Make sure you test the Backups though, that’s just good business practise.

Regards

Marius

Thank you,

Tiberiu

[Non-text portions of this message have been removed]