Lotus Notes ver. 6.5.1 - Need advice/direction on best transaction recovery process.
Posted on 2005-03-23
Hello...Could someone provide a brief explanation or provide a url that offers a possible direction on how to recover from an error on a "batch' update. We do not want to rely on restoring from back-ups as this "batch' update is run multiple times each day.
I have a button on a form that launches lotusscript that reads/updates many detail records (documents)....if for some reason the process errors half way thru the batch, I need a means of fast recovery, to restore the updated documents to their original state.
In a true database environment, one can use commit/rollback.
I can only see writing a separate piece of code that identifies the documents updated and undo everything the original code put in place.
Is there any other means of "file" restoration.
Writing perfect code that never allows an error is one solution.....is there any other?