Re: [firebird-support] nbackup

2017-06-02 Thread hugo.lar...@yahoo.com [firebird-support]
Hi, Interesting that FB 3.0 reduces the nbackup time. Thanks for the info. We have so many installations so I think we will wait for FB 4.0 which have incremental nbackup restore and native replication. BR, Fadi

Re: [firebird-support] Ask : firebird 1.5 to firebird 2.5

2017-06-02 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
02.06.2017 8:54, 'Vonica Tng (Madsoft)' vonica@madsoft.com.sg [firebird-support] wrote: > What is the size of the database that we can test to show the speed > significance between > Firebird 1.5 and Firebird 2.5? One terabyte should be enough. But what's the point to migrate to 2.5

Re: [firebird-support] nbackup

2017-06-02 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Hi Hugo, Yes, in this case you can check MON$ tables. Please note that in case of many connections query to MON$ can consume significant resources. How do you recover if it's stuck? nbackup -n >I noticed that the larger the database is the longer it takes to do nbackup even if the delta

Re: [firebird-support] nbackup

2017-06-02 Thread hugo.lar...@yahoo.com [firebird-support]
Hi Alexey, In my case the database is seldom larger 500 MB and the backup takes 30 maximum seconds. Would it not be sufficient to check the MON$BACKUP_STATE field (thanks Thomas) and if its stuck on state 1 or 2 for several minutes then I execute "ALTER DATABASE END BACKUP". How do you

[firebird-support] Ask : firebird 1.5 to firebird 2.5

2017-06-02 Thread 'Vonica Tng (Madsoft)' vonica....@madsoft.com.sg [firebird-support]
Dear Sir / Madam, What is the size of the database that we can test to show the speed significance between Firebird 1.5 and Firebird 2.5? Vonica Tng Sales & Marketing Support Executive MadSoft Solutions Pte Ltd (formerly known as QnE Consultants Pte Ltd) 178 Paya Lebar Road