Subject RE: [firebird-support] database gone after server reboot
Author Helen Borrie
At 06:12 p.m. 16/04/2014, Bogdan wrote:
>Why do you have RESERVE set to ON ?

I don't know why you ask this question. RESERVE is the default (and recommended) setting for a read/write database. It can be set OFF for a read-only database, since there is no need to reserve space on data pages to allow for efficient [re-]use of available space.

In any case, the RESERVE setting has no relevance to the problem described by the OP. "Disappearing database" is an unknown phenomenon. The only way that Firebird can delete a database is by a client connecting to it and issuing a DROP DATABASE command. A server admin could delete the file or run a script that connects to the database as a client and performs DROP DATABASE.

I think the OP has to go back to the admins of those two servers and do some forensics. For protective measures, remove shares from folders that contain databases, review any scripts that might be running on boot-up and limit file system access to those who know what they are doing.

Helen Borrie, Support Consultant, IBPhoenix (Pacific)
Author of "The Firebird Book" and "The Firebird Book Second Edition"