Subject Re: [firebird-support] RE: Advice on storing large numbers of documents in a Firebird database
Author marcus

miker169@... wrote:
> > The only issue is that once the DB gets to a certain size it can be a
> pain to do a full backup/restore
> Steve, thank you for your response. Please can you let me know a bit
> more about the backup problems you are having and any possible
> strategies you have to mitigate them.
not Steve, but a little bit of knowledge i'd like to share:
-when storing documents inside the database by using blobs, the only
real problem is the time a backup or restore of the database needs.
And the performance depends on several variables, such as what type of
hard disk, raid - and what type of raid, database and backup on separate
disks or even on separate engines, network,....
as you can see - a lot of parameters have influence to that 'problem'.

One possible strategie would be to store metadata and only store links
to the documents.

> For example I thought it was possible to shutdown the server and use
> operating system services (i.e. SCP?) to copy the file?
That would be a save copy, but you'll never be shure if the database
structure is fine. A possibility would be to copy the database to
another server and perform a backup/restore cycle there.

hth, marcus

> Many thanks...Mick