On Wed, Jun 1, 2011 at 12:27 AM, robert.gilland
<robert.gilland@...> wrote:

> I have read the nbackup documentation. ( using firebird 2.1.3 )
> I am still confused as to whether it can help me.
>
> i need to
>
> 1. start a backup.( nbackup )

Fine.

> 2. keep live database active and importing data.

Fine.

> 3. start a restore. ( nbackup )

Fine.

> 4. All data from live database needs to merge into newly restored database. ( nbackup )

Fine.

> 5. After finished I expect the Oldest Transaction to be a lot smaller number.

No. nbackup is a physical, page by page copy of the database. It has many
advantages over gbak, including incremental backups and the ability to reflect
changes made during the backup. But only gbak (or another dump/reload
program) can change transaction id's on stored records.

>
> Can nbackup do this?

No.

> At what point in time must I stop import of data. To ensure no loss of data?

With nbackup, all changes will be preserved.

Good luck,

Ann