Vasily Vasilkov skriver:

>
>
> > For an online system with moderate number of users (maybe 100 tops) but
> > large data volmes (> 100 million records in some tables, 35+ gigabyte
> > FDB file), what would be the recommended backup scheme?
>
> You can try nbackup utility if you are using Firebird 2.X.
>
> Nbackup allow you to make incremental backups of your database, for
> example, your backup scheme may looks like:
> backup level 0 - every month
> backup level 1 - every week
> backup level 2 - every day
> backup level 3 - every hour
>
> Read the manual here: http://www.firebirdsql.org/manual/nbackup.html

Thanks! Looks useful!

Still, it doesn't make sure I can recover ALL committed transactions. It
still leaves a small window of data loss.

Is there any way I can make sure I can restore EVERYTHING that's
committed to the database, in case of a crash?

Since the database will eventually be used by our customers to place
orders, this could become somewhat important.

Regards,
Kjell
--
------------------------------
Kjell Rilbe
DataDIA AB
E-post: kjell.rilbe@...
Telefon: 08-761 06 55
Mobil: 0733-44 24 64


[Non-text portions of this message have been removed]