I trying to figure out how to purge all the deleted documents in my names.nsf file. I have tried running a fixup followed by a compact and changing the remove after X number of days in the replication settings and nothing seems to remove all the documents for objects that no longer exist in my address book. I’m trying to use the notessql driver so I can look at some data and I have names that shouldn’t be there showing up in the report.
Any direction on how to accomplish this would be great.
Thanks in advance.
Subject: Purging Deleted Docs
This is very commonly answered question here.
First make sure your domino directories on all your servers are in sync. Then go to the replication settions. There you will see a number usually 90 on the line:
“Remove document not modified in the last: ___ days”
The number in this setting is use to calculate when deletions stubs will be removed by the compact process. FIXUP does not remove deletion stubs. The formula is x * (1/3) where x is the value in the above setting. So if it is 90 (as default in most newly created databases) then it means every 30 days after the inital number days – it will check to find out what needs to be deleted. So a document deleted in the database would be removed 120 days after.
If the database has a lot of deletion happening, I would move this number to a smaller interval.
HTH – Cheers