Re: [firebird-support] GBAK and NBAK restore

2018-09-15 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.09.2018 13:48, hugo.lar...@yahoo.com [firebird-support] wrote: > Unfortunately 2.5 does not have replication. There are third-party tools for replication and ETL as well. -- WBR, SD.

Re: [firebird-support] GBAK and NBAK restore

2018-09-14 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 13-9-2018 23:05, hugo.lar...@yahoo.com [firebird-support] wrote: > > >> Do you mean you increase the back up level continuously? > > Yes > My strategy is: > Level 0 once. > Increment level continuously every third Day. > > Works fine most of the times. Sometimes I get mysteriously the

Re: [firebird-support] GBAK and NBAK restore

2018-09-14 Thread hugo.lar...@yahoo.com [firebird-support]
Hi, Unfortunately 2.5 does not have replication. I'm desperately waiting for FB4. Thx,

Re: [firebird-support] GBAK and NBAK restore

2018-09-13 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 2018-09-13 14:04, hugo.lar...@yahoo.com [firebird-support] wrote: > Hi Mark, > > Thank for the explanation. > > What about restoring (GBAK) both databases at a particular moment then > they should be even "physically" identical at that moment? At this > moment it's level 0. > But then you

Re: [firebird-support] GBAK and NBAK restore

2018-09-13 Thread hugo.lar...@yahoo.com [firebird-support]
Hi Mark, Thank for the explanation. What about restoring (GBAK) both databases at a particular moment then they should be even "physically" identical at that moment? At this moment it's level 0. But then you have tell the source db where level 1 starts. Maybe by inserting something in

Re: [firebird-support] GBAK and NBAK restore

2018-09-13 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
13.09.2018 11:14, hugo.lar...@yahoo.com [firebird-support] wrote: > I appreciate any advice on this issue. I'd suggest you using of replication instead of backups. It can significantly reduce size of transferred data. You also can use ETL tools that are able not to export old/unchanged

Re: [firebird-support] GBAK and NBAK restore

2018-09-13 Thread Mark Rotteveel m...@lawinegevaar.nl [firebird-support]
On 13-9-2018 11:14, hugo.lar...@yahoo.com [firebird-support] wrote: > We have hundreds of Firebird SQL 2.5 running at customers site (shops) > with limited Internet bandwidth. The application is a POS system. > For backup we use incremental NBAK and send the N file to a remote host > which are

[firebird-support] GBAK and NBAK restore

2018-09-13 Thread hugo.lar...@yahoo.com [firebird-support]
Hello, We have hundreds of Firebird SQL 2.5 running at customers site (shops) with limited Internet bandwidth. The application is a POS system. For backup we use incremental NBAK and send the N file to a remote host which are restored on the server to display sale statistics etc. When