Re: [Firebird-devel] non-transportable backup using without "-seservice_mgr" results in an backup file ~50% larger than the source database

[Brenden W. <BKW...@dr...>]

> -----Original Message-----
> From: Alex Peshkoff [mailto:pes...@ma...]
> Sent: Friday, October 15, 2010 2:44 AM
> To: fir...@li...
> Subject: Re: [Firebird-devel] non-transportable backup using without "-
> seservice_mgr" results in an backup file ~50% larger than the source
> database
> 
>  On 10/14/10 19:13, Brenden Walker wrote:
> >> -----Original Message-----
> >> From: Alex Peshkoff [mailto:pes...@ma...]
> >> Sent: Thursday, October 14, 2010 2:35 AM
<snip>
> > Here are the two test backup command lines I used.
> >
> > c:gbak.exe -se service_mgr -v -nt -user sysdba -password masterkey
> d:\temp\i21426\2.5\smalltest\sw_even_smaller.fdb
> d:\temp\i21426\2.5\smalltest\service_mgr.fbk
> >
> > c:gbak.exe -v -nt -user sysdba -password masterkey
> d:\temp\i21426\2.5\smalltest\sw_even_smaller.fdb
> d:\temp\i21426\2.5\smalltest\no_service_mgr.fbk
> >
> >
> > Here's the directory contents:
> >
> > Directory of D:\temp\i21426\2.5\smalltest
> >
> > 10/14/2010  11:06 AM    <DIR>          .
> > 10/14/2010  11:06 AM    <DIR>          ..
> > 10/14/2010  11:04 AM       175,974,400 no_service_mgr.fbk
> > 10/14/2010  11:07 AM       167,070,720 service_mgr.fbk
> > 10/14/2010  11:07 AM       367,902,720 SW_EVEN_SMALLER.FDB
> >
> >
> > The difference in file size isn't as large, however I would think
> that whether using -se service_mgr or not the resulting FBK should be
> the same size.
> Yes, certainly.
> Can you compress that fdb and make it available for download?

The backups will be a tad smaller than noted above (dropped a table with employee information), however the disparity of backup file size is still present.


http://www.diablops.com/dlfiles/BackupTestDB.zip


Thanks for looking into this.