Preventing database corruption on Ruby

[Belinda Frick]

1. Install a UPS
Even a small UPS (5 minutes battery time) is sufficient. The goal is to shut down the PC safely
when the power fails. Make sure that the UPS software is installed and configured to shut the PC down.

2. Use a reliable filesystem
Make sure you are running the database on Linux or on Windows 2000/XP/2003, not Windows 95/98/ME.
Also make sure that the file system is NTFS, and not FAT32, if you are using Windows. If you are
using Linux, use EXT3, ReiserFS, JFS or XFS.

3. Enable Forced Writes
To minimise the risk of database damage if there is no UPS or if there is a problem with the UPS,
make sure that "Forced Writes" is enabled. This forces the database to write data to disk
immediately instead of keeping the data in memory, which is normally done to improve performance.

To enable forced writes, right-click on the database in IBConsole and enable Forced Writes.

You can also cut and paste the following commands into a batch file and run it:

@echo off

set ISC_USER=SYSDBA
set ISC_PASSWORD=masterkey
PATH=%PATH%;C:\Program Files\Borland\Interbase\bin
cd "C:\Program Files\Datatex\Ruby2\Data"

echo "Enabling forced writes..."
gfix -write sync ruby.gdb

pause