Subject | Re: [firebird-support] Backup strategy for large db - was Re: Blobs in DB or file system. |
---|---|
Author | Steve Wiser |
Post date | 2006-11-28T21:56:52Z |
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:
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?
>
>