I am not using the sql version but today I had a disaster and the main file was cleared. However I was able to ask gnucash to open my .xac file from last night. As far as I can tell everything seems fine and I only had to re-enter the transactions from today. Dale Alspach