Subject nbackup : Error assessing database due a missing delta file
Author Jorge Gonçalves
Post date 2017-08-02T19:37:38Z
Hi,

I'm having a problem assessing a database due a missing delta file in our datacenter.
I have tried the flowing commands to repair the database without success. 


nbackup -F 506408949.mycloudpie.com
Failure: Database is not in state (2048) to be safely fixed up


nbackup -N 506408949.mycloudpie.com
[
PROBLEM ON "attach database".
I/O error during "open" operation for file "/srv/databases/firebird/ 506408949.mycloudpie.com.fdb. delta"
-Error while trying to open file
-No such file or directory
SQLCODE:-902
]
Failure: Database error


Any ideas how to recover the database ?

ps  : This problem arises sometimes in our datacenter and our IT guys don't now the reason for that. Any idea how to prevent this problem to appear again in the future ?

FB Version : 2.5.2.26539
Server :  Opensuse 13.1

 Regards
jGoncalves