The fbsvcmgr method requires fb 2.5.2. The upside is you can run it remotely :)
2014-10-14 10:01 GMT+03:00 'Marius Labuschagne' [email protected] [firebird-support] < [email protected]>: > > > From: [email protected] [mailto: > [email protected]] > Sent: 14 October 2014 08:33 AM > To: [email protected] > 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] > > >
