Better yet, use fbsvcmgr remotehost:service_mgr -user sysdba -password XXX action_backup -dbname some.fdb -bkp_file stdout >some.fbk
2014-10-13 16:18 GMT+03:00 Thomas Steinmaurer [email protected] [firebird-support] <[email protected]>: > > > > <Are you running gbak from your local client machine against a remote > > <server/database and creating the backup file on your local machine? I If > > <so, this is not a good idea from a performance perspective. > > > > I run the backup automatically each night (Windows scheduled tasks), for > > a few of my customers, via the Internet. > > Ok, even worse. > > > And yes, I need the backup file locally, on my system. > > > > As I mentioned before, if the backup lasts for 10 minutes of which > > log_tables takes 9 , no problem at all, FireBird works like a charm for > > me (with Delphi XE5), I was just asking why this huge difference between > > backing up tables with or without BLOB tables. > > Can you please try my previously posted gbak call, because this will > force to run everything on the remote machine. Just to get an idea on > how much this is faster. > > -- > With regards, > Thomas Steinmaurer > http://www.upscene.com/ > > Professional Tools and Services for Firebird > FB TraceManager, IB LogManager, Database Health Check, Tuning etc. > >
