Subject Table getting corrupted on server reboot
Author mes.rahul

I am running Firebird on a WinXP machine in Super Server mode. I am running an application on the PC which needs to collect data on a 24 x 7 basis and store it in a Firebird database.

The application works fine until the PC is rebooted. When this is done, one particular table is getting corrupted. This table has a fixed number of rows. A row is updated with fresh data every second in this table. To restore functionality, I have to either drop and recreate the table or do a DB backup-restore.

Can someone please tell me why this could be happening or how I can prevent this corruption?