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

[Alex P. <pes...@ma...>]

 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.
>
> I performed most of these tests with 2.1.3.18185, however I just tested again with 2.5.0.26074 and the results were the same.
>
> In short, source database is roughly 21gig, freshly restored from and .fbk
>
> If I backup with the below command:
> gbak.exe -y d:\temp\i21426\backup.log -se service_mgr -v -nt -user sysdba -password masterkey d:\temp\i21426\SW.fdb d:\temp\i21426\SW.fbk
>
> Results in 13,257,345KB file, took approximately 31 minutes.  Likely what one would expect.
>
> However dropping "-se service_mgr" from the above results in a huge FBK file 32,220,963KB file.
>
> Backing up the same database in transportable format results in an even smaller file (11,205,556KB) with the file size being exactly the 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?