RE: [firebird-support] Restoring Backup

2016-02-24 Thread 'Leyne, Sean' s...@broadviewsoftware.com [firebird-support]
Dimitry, > > When it is restoring data, it > > fills a data page and goes on to the next one. A large cache will > > fill with pages that will not be referenced again until the indexes > > are built. To build indexes, Firebird reads records and sorts by > > keys. That might suggest that

Re: [firebird-support] Restoring Backup

2016-02-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.02.2016 21:30, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: > I am not sure that is the best way Yes, gfix is better. At least faster. -- WBR, SD.

Re: [firebird-support] Restoring Backup

2016-02-24 Thread Hugo Eyng hugoe...@msn.com [firebird-support]
Hello Ann. Thank you very much. The two hundred pages are not intended to be used for backup or restore purposes. In fact, I use the switche '-BU 20', in gbak -REP -c, to set the database cache pages option. This way I don´t need change the DefaultDbCachePages switche in the

Re: [firebird-support] Restoring Backup

2016-02-24 Thread Dimitry Sibiryakov s...@ibphoenix.com [firebird-support]
24.02.2016 20:37, Ann Harrison aharri...@ibphoenix.com [firebird-support] wrote: > When it is restoring data, it > fills a data page and goes on to the next one. A large cache will fill with > pages that will not be referenced again until the indexes are built. To > build indexes, Firebird reads

Re: [firebird-support] Restoring Backup

2016-02-24 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Wed, Feb 24, 2016 at 12:01 PM, Hugo Eyng hugoe...@msn.com [firebird-support] wrote: Referring to the buffers requested for gbak: > > > Why 12? Why not? :) > There's a cost to managing a large buffer cache. Firebird will use the entire cache even if

Re: [firebird-support] Restoring Backup

2016-02-24 Thread Hugo Eyng hugoe...@msn.com [firebird-support]
Hello HB. It happens with 2.5.5 32 bit. I believe that the limitation is beacuse 20 x 16384 (page size) = 3GB greater than the avaliable amount of memory or greater than the 32bit engine is capable to manage. I am not sure. Why 12? Why not? :) Hugo Em 24/02/2016 00:09, Helen

Re: [firebird-support] Restoring Backup

2016-02-23 Thread Helen Borrie hele...@iinet.net.au [firebird-support]
Wednesday, February 24, 2016, 12:22:31 PM, Hugo Eyng wrote: > Hello. > I tried to restore a backup using the -BU 20 switch and gbak > returned an error message: invalid parameter. That is not a gbak message. If you are using a third-party tool, it is likely to be some limit imposed by

[firebird-support] Restoring Backup

2016-02-23 Thread Hugo Eyng hugoe...@msn.com [firebird-support]
Hello. I tried to restore a backup using the -BU 20 switch and gbak returned an error message: invalid parameter. Then I change the value 20 by 12 and gbak worked. Is it a limitation? switches -- Atenciosamente, Hugo Eyng

Re: [firebird-support] Restoring backup from 2.5 to 2.1

2012-07-06 Thread Milan Babuskov
Aldo Caruso wrote: When I try to restore a backup done in a 2.5 firebird server to a 2.1 firebird server, I get the following error message: gbak:transportable backup -- data in XDR format gbak: ERROR:Expected backup version 1..8. Found 9 gbak:Exiting before completion due to errors

[firebird-support] Restoring backup from 2.5 to 2.1

2012-07-04 Thread Aldo Caruso
Hi, When I try to restore a backup done in a 2.5 firebird server to a 2.1 firebird server, I get the following error message: gbak:transportable backup -- data in XDR format gbak: ERROR:Expected backup version 1..8. Found 9 gbak:Exiting before completion due to errors Isn't it possible

Re: [firebird-support] Restoring backup from 2.5 to 2.1

2012-07-04 Thread Thomas Steinmaurer
When I try to restore a backup done in a 2.5 firebird server to a 2.1 firebird server, I get the following error message: gbak:transportable backup -- data in XDR format gbak: ERROR:Expected backup version 1..8. Found 9 gbak:Exiting before completion due to errors Isn't it

Re: [firebird-support] Restoring backup from 2.5 to 2.1

2012-07-04 Thread Alexandre Benson Smith
Did you tried to use 2.1 gbak against 2.5 server to produce the gbk ? see you ! Em 4/7/2012 15:59, Aldo Caruso escreveu: To restore, I am using gbak 2.1 against a 2.1 server, but reading a *.fbk backup file that was created using a 2.5 server. AFAIK I'm not using specific things from 2.5

Re: [firebird-support] Restoring backup from 2.5 to 2.1

2012-07-04 Thread Aldo Caruso
Good idea, but it is unfeasible for me because the server is remote on Internet (with very high latency), so I have to create the back ups on the server, download the file and apply it to my local machine (which has firebird 2.1) Thanks, Aldo El 04/07/12 16:04, Alexandre Benson Smith

Re: [firebird-support] Restoring backup from 2.5 to 2.1

2012-07-04 Thread Helen Borrie
El 04/07/12 16:04, Alexandre Benson Smith escribió: Did you tried to use 2.1 gbak against 2.5 server to produce the gbk ? At 07:11 AM 5/07/2012, Aldo Caruso wrote: Good idea, but it is unfeasible for me because the server is remote on Internet (with very high latency), so I have to create the

RE: [firebird-support] Restoring backup from 2.5 to 2.1 - Email found in subject

2012-07-04 Thread Leyne, Sean
Good idea, but it is unfeasible for me because the server is remote on Internet (with very high latency), so I have to create the back ups on the server, download the file and apply it to my local machine (which has firebird 2.1) You could copy the v2.1 GBAK executable onto the remote

Re: [firebird-support] Restoring backup from 2.5 to 2.1 - Email found in subject

2012-07-04 Thread Aldo Caruso
Thanks for your idea. Aldo El 04/07/12 16:49, Leyne, Sean escribió: Good idea, but it is unfeasible for me because the server is remote on Internet (with very high latency), so I have to create the back ups on the server, download the file and apply it to my local machine (which has