I’ve been asked a number of times by people who use Notes about databases with not too many documents in them yet lots of space consumed. This is particularly important when trying to free up space with low quotas imposed. The problem comes down to the fact that with local replicas the indexes created to allow notes to open views and folders quickly may not get discarded if they are unused. Hence if you have lots of folders your mail file size may grow to a point where documents only form a small portion of the overall size. I’ve simplified things here…
In most cases the compact performed from within the notes client only gets rid of the space freed up from deleting documents. So if you find you are having problems getting below a quota try this:
- Open a command prompt (one way to do this is to click start – run – enter “cmd”)
- You’ll need to know the folder your lotus notes executables sit in.
- Then change directory to that folder. That may be cd “c:program fileslotusnotes” but in later versions of notes that has changed.
- Next you’ll need to know where your data files are. In my case it is c:program fileslotusnotesdata
- Now the magic command to get rid of indexes and the space left from deleting documents
ncompact.exe “TheFullPathToYourMailFile” –D
In my case it is ncompact.exe “c:program fileslotusnotesdatamailsdownes.nsf” -D
I’m sure someone who reads this will have a wonderful script which runs from a button 🙂 If you have lets see it 🙂