Hej, [email protected] 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 > > >
