RE: [firebird-support] Why a database grows after a cycle backup/restore?
Walter, > Which can be the cause that a database of 3.1 gigabytes grows to 4.2 > gigabytes after a cycle backup/restore? > > The file FIREBIRD.CONF seems normal, nothing strange there. > > Growing 1.1 gigabytes seems to me too much. To be clear, it is source database or the backup file 3.1GB? Sean
Re: [firebird-support] Why a database grows after a cycle backup/restore?
The source database has 3.1 Gb but after the backup/restore have 4.2 Gb Seems very strange for me. Greetings. Walter. On Tue, Jun 18, 2013 at 6:03 PM, Leyne, Sean wrote: > ** > > > Walter, > > > > Which can be the cause that a database of 3.1 gigabytes grows to 4.2 > > gigabytes after a cycle backup/restore? > > > > The file FIREBIRD.CONF seems normal, nothing strange there. > > > > Growing 1.1 gigabytes seems to me too much. > > To be clear, it is source database or the backup file 3.1GB? > > Sean > > > [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [firebird-support] Why a database grows after a cycle backup/restore?
Em 18/6/2013 19:44, W O escreveu: > The source database has 3.1 Gb but after the backup/restore have 4.2 Gb > > Seems very strange for me. > > Greetings. > > Walter. > > Just a shot in the dark... Could be that the original database was restored with -USE_ALL_SPACE and the new database was not be restored with the same option ? see you !
Re: [firebird-support] Why a database grows after a cycle backup/restore?
Hi Walter, Please post here the exact full commands for backup and restore. Also please tell what is Firebird version. Regards, Alexey Kovyazin IBSurgeon > Hello everybody > > Which can be the cause that a database of 3.1 gigabytes grows to 4.2 > gigabytes after a cycle backup/restore? > > The file FIREBIRD.CONF seems normal, nothing strange there. > > Growing 1.1 gigabytes seems to me too much. > > Greetings. > > Walter. > > [Non-text portions of this message have been removed] > [Non-text portions of this message have been removed]
Re: [firebird-support] Why a database grows after a cycle backup/restore?
> The source database has 3.1 Gb but after the backup/restore have 4.2 Gb Did you specify a larger page size for the restore? Regards Stefan
Re: [firebird-support] Why a database grows after a cycle backup/restore?
Hi Walter, >C:\Archivos de programa\Firebird\Firebird_2_5\bin\Gbak -c -v -t -rep -p 8192 >-user SYSDBA -password masterkey D:\RestaurarBASES\BDRestaurada\BASE.GBK >127.0.0.1:D:\RestaurarBASES\BDRestaurada\BASE.FDB -FIX_FSS_D ISO8859_1 -FIX_FSS_MISO8859_1 This is the answer why database grows: -FIX_FSS_D ISO8859_1 -FIX_FSS_MISO8859_1 You should apply this option only once, when upgrading from 2.1. If you apply it every time, you do transliteration every time and database size will grow. Regards, Alexey Kovyazin IBSurgeon [Non-text portions of this message have been removed]