Subject Re: [firebird-support] GBak TPB
Author Helen Borrie
At 05:59 AM 24/04/2008, you wrote:
>Hi
>
>What TPB (transaction parameter buffer) is used by GBak?

Isolation concurrency (snapshot), mode read-only, lock resolution wait....


>I need to make my own small version of gbak to export all tables except
>for one, which gets exported in the form of one record = one file
>(images in a blob).

Look at DBak - http://www.telesiscomputing.com You can filter out any object that you don't want to back up.


>I need this for incremental remote backup. The images are never
>modified, so it is not good to transfer them every night.

Gbak doesn't (and can't) do incremental backup.

>One way to solve it, is to store the images outside the database, but
>since we don't allow shared folders, that is not an option.

Another way is store the images in a separate database. This presupposes that you are using a data access interface that supports two-phase transactions, of course. The down-side is that your application code is totally responsible for maintaining the referential integrity between the records in the master database and those in the image database. It is doable, however.

./heLen