I'm member in a team that have bought Interbase 2009. We have 2 identical servers running Windows 2003, one liveserver running production database (around 18 GB). And one testserver for development and test. The data is business critical and now we take backup every night with gbak -b.
But still we can loose a whole day of work in case of hardware failure. According the doc Interbase can archive the production database on liveserver and then store changes in journal files on another computer. In this case Testserver. This should be done often, ideally after every commit on the production database.
When/If hardware fails on liveserver we should be able to take the database archive and then apply the latest changes from journal files to get all committed data before the failure.
The problem is that we cannot get this to work. Is there someone that have experience with journaling in Interbase and can help us with this ?
We have studied chapter 8 and 9 of Interbase doc in opguide.pdf but when we test the gbak commands on the prompt this don't work at all.
Please help if someone have done this!
Sinceraly.