URGENT please - Undeleting field values?

HCL Domino Domino Forum
1

Disaster; I ran an agent that was supposed to delete field values out of just one document but it did to all in the view.

Does anyone know if there is a way to restore field values?

OR am I doomed?

2

Subject: URGENT please - Undeleting field values??

Hi sorry to say this but you are proberbly doomed :-((

If you change the values of a field (or delete it) there is nowhere the former value stored and it cant

be recovered. (If the whole doc were deleted you had chance that it si only “soft deletion”)

You will have to use data from a backup. This can be:

  • a real backup of the database (on tape or something)

  • a replica of the database which has not replicated since the change (maybe a local one ?,if such exists prevent it from replicating)

Good luck and hope you find one.

Bye

Hynek

PS: Do you have “transactional logging” enabled ?

If yes there might be a chance that the changes were not written to the database yet ?

I dont know much about transactional logging but it is possible that it could help you.

3

Subject: RE: URGENT please - Undeleting field values??

Thanks ever so much for prompt reply. Not all is lost cos I have a back up from last night. However, today’s work is definitely lost :frowning:

4

Subject: If you have transaction logs + backup software you should be fine

You can roll back the database to any point in time if you have the transaction logs and backup software that lets you take advantage of them.

Rob

5

Subject: URGENT please - Undeleting field values??

Pray you had a backup. I always back up before running an agent just in case for this exact reason.

6

Subject: RE: URGENT please - Undeleting field values??

Yes I did, from last night. But it was today’s work I was most concerned.

7

Subject: RE: URGENT please - Undeleting field values??

Hi,

it depends a lot on your data and how much the database is used but you could consider

that instead of replacing the database with the backup-version you could “return” only the field

values from the backup.

This would have to be done with an agent which would find the appropriate document and then write only the field

back. It could have some disadvantages but you should consider this solution as well.

(Even after your bad expierience with agents :-)))

Bye

Hynek