Link to home
Start Free TrialLog in
Avatar of mchampou
mchampou

asked on

How to remove Deletion Stubs from a database ?

Hi everyone,

I have a might big problem. I have a database that had a ton of document deleted from it. I can restore thoses documents (I know which one were deleted) from a tape backup copy of the database.

Problem is, after copying the documents from my backup copy to the live copy, the first time it replicate : all the documents are deleted again ...

The answer is pretty simple : it's because the deletion stubs have been copied over to the other replicas ...

Is there a way to remove the stubs from the replicas ? I cannot aford to change the Document Unique IDs simply because there is another database that uses doc-links to that database. I cannot afford either to "flush" the other replicas and create a fresh replica over because the database size is over 700 megs.

Thanks for any help you can provide ;-)

Mchampou
ASKER CERTIFIED SOLUTION
Avatar of pentapod
pentapod

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of pentapod
pentapod

Ah - I just re-reread your question and realised I thought you were asking a slightly different question.  However I hope the Purge Interval settings I mentioned might solve your problem?

....Pentapod
Avatar of mchampou

ASKER

No you are right on the money, you understood my need.

I will need to test this before I can give you the points. Is that ok with you ?

mchampou
Sure thing!  Good luck!!

....Pentapod
Thanks for your help, your answer helped me fix our problem.

Sincere thanks !

mchampou
My pleasure!  Glad our pain and panic could be of help to you!  Just gives ya warm fuzzies thinking about it.

....Pentapod