You are viewing limited content. For full access, please sign in.

Question

Question

Restore a deleted annotation

asked on August 28, 2014

Is it possible to restore a sticky note after it has been deleted? Does the text reside in SQL disassociated to the entry by chance?

 

Someone accidentally deleted something they wish they had not.....

 

Thank you in advance!

0 0

Answer

APPROVED ANSWER SELECTED ANSWER
replied on August 28, 2014

You'll have to restore a backup of the database. The sticky note text is stored in the ann table, but when the annotation is deleted, so is the corresponding row. As for trying to find the correct annotation to recover from the restored database, you can use the page_id of the specific page (found in the doc table based off of the entry id and page number) and the ann_type (8 for sticky notes).

1 0

Replies

replied on September 9, 2021 Show version history

I know this is an old post, but I just ran into the same situation today.  Instead of doing DB restores, I went to the audit log and found all of the changes to the annotations on the document.

The last modification to the Sticky note contained the text before it was deleted. 

I sent the text to the user so that they could create a new Sticky note and paste the text in.

StickyNoteText.png
1 0
You are not allowed to follow up in this post.

Sign in to reply to this post.