On 07.04.2015 08:16, Vishal Tiwari [email protected] [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]
