Re: [Firebird-devel] non-transportable backup using without "-se service_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: Thursday, October 14, 2010 2:35 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/13/10 23:24, Brenden Walker wrote:
> > I originally posted this to firebird-support and didn't get any
> feedback, figured I'd post here before entering an issue.
> >
<..snip>
> same whether I specify "-se service_mgr" or not, so this appears to be
> specific to the non transportable format.
> >
> > I searched the tracker and wasn't able to find an existing issue for
> this.  I'll add one if that's the correct next step, I just wanted to
> run this by someone before doing so.
> >
> > We could likely provide the source database on HD if needed, although
> I'd probably want to remove more sensitive customer information and
> retest prior to doing so (for obvious reasons).
> Looks like a bug. 2 questions:
> Can you reproduce an issue with database of smaller size?
> Are both non-transportable backups (big and small) restorable?

I was able to shrink the database by dropping tables.  The non-service manager backup is no longer larger than the FDB, *however* the .fbk file size is larger than when using the service manager.  I think this is still exhibiting the problem, just not as pronounced.

The database is now 359,280K.

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.