Subject Re: [firebird-support] Backup strategy for large db - was Re: Blobs in DB or file system.
Author Steve Wiser
Right now we are not backing it up using gbak. Just dumping the
filesystem to tape nightly (we kill connections to the server during a
maintenance period) and also doing sweeps nightly.

-steve

Bob Murdoch wrote:
>
> Steve,
>
> > -----Original Message-----
> > From: Steve Wiser [mailto:steve@...
> <mailto:steve%40specializedbusinesssoftware.com>]
> > 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?
>
>