On 07.04.2015 08:16, Vishal Tiwari vishualsoft@...
[firebird-support] wrote:

>
>
> Then what could be the best way to reduce the database size?
>
> All suggestions are appreciated.

Hej Vishal

played around a little bit, unable to reproduce your problem.
Even after setting some blobfields to NULL, leaving isql or flamerobin
open and the update statement uncommitted, gbak -b with -l or -g or -l
and -g : the backup files are all distinctly smaller than the backup
with all blob content. Same for all the restored databases.

What i've done:
- System Win7 64, FB 2.5.2
- created a new database, new table t1 (id integer, blobfield blob
subtype 0), all operations in the same directory
- create first backup for empty db
- insert 10 ids and random blob data
- create second backup
- update t1 set blob=null where id > 2
- leave either flamerobin or isql statement uncommited
- backup db to different names: both smaller than second backup
- playing with backup options, backup to different names: still
smaller than than the second backup
- commit statement
- backup db to different names: both smaller than second backup
- playing with backup options, backup to different names: still
smaller than than the second backup
- restore all the backups to according names: size equals between all
backups where i've done the update...set...null, all smaller than the
original database with all 10 blobs.
- opened all databases: blobs 3..10 are NULL

So, question is: how do you do your backup/restore? cmd, service api,
some 3rd Party components?
Doublechecked file locations? Stumpled upon that to often for myself.

hth, Marcus

>
>
> With Best Regards.
>
> Vishal
>
>

[Non-text portions of this message have been removed]