|Subject||RE: [firebird-support] database gone after server reboot|
> I have two client server applications that are installed in over 200 sites. TheI have never seen* this in 20+ years using IB/FB.
> applications each use a database, db1 and db2. In the past six months, we've
> had two strange occurrences. After a scheduled server reboot (Win 2008
> R2), the db1 file is missing. Luckily, each company does a backup each night,
> so it was just a matter of restoring the database.
> Has anyone encountered something like this before? Ideas on how to
> prevent this from happening in the future?
Confirm the state "Forced Write" database flag for the databases.
It also seems as if your database is being created on a drive "snapshot" which is being rolled back when the system is rebooted -- very odd.
* I can't recall even _hearing_ of this happening (I have read practically every support mailing list post in the last 18 years).