Bob,

> > -----Original Message-----
> > From: Steve Wiser [mailto:steve@...]
> > Sent: Tuesday, November 28, 2006 2:37 PM
> >
> > Regarding the 2 Gig limit, that doesn't apply to the size of
> > the blobs, just the data records. We have a 100 GB
> > database consisting of 3 image tables and haven't run
> > into any limits. Some tables store the images as
> > a set file type, some tables store the blob and also the file
> > type so we can read the data when it is pulled out.
>
> Can you share your backup strategies for this database?

Firebird v2.0 contains a new type of backup tool -- nbackup.

Nbackup allows you to make full 'image' and multi-level incremental
backups of a Firebird database.

Unlike gbak, nbackup operates at the database page level as such, it
operates at much, much higher speeds (as much as 2GB per second --
Gigabyte, not Gigabit!)

Further, nbackup also allows you to set the database file into a mode
which allows you to make tape backups of the database while it is still
online.


Sean