Fixing a Notes database

When upgrading a server or moving datbases I like to apply a little hygiene to my notes databases. So you can find a little cmd file in the notes data directory, that fixes what needs to be fixed:

Fixnotesdb.cmd
nfixup -L -F -Y %1
ncompact -D -c -i -n -v -ZU %1
nupdall -R %1
nupdall -X %1

Running the script with the server down has the advantage, thay you can fix the address book as well. On R8.5 you want to have CREATE_R85_DATABASES=1 in the notes.ini. The only disadvantage: you need to type the password 4 times (unless your server doesn't need one). If you don't have a password, you could add:
net start "domino (lotusnotesdata)" <-- be sure to check your services for your settings!
at the end of the script and it would relaunch your server after it has run. YMMV.

Update: There is a Linux version too.
Update 2: There is a Mac version too

Update 3: for R9.0.1FP8 onwards you want to use ncompact -D -c -i -n -v -ZU -nifnsf -LargeSummary %1

Posted by Stephan H Wissel on 16 January 2006 | Comments (4) | categories: IBM Notes Lotus Notes

posted by Skunk on Monday 28 March 2011 AD:
Im using this command as you mentioned. but unfortunetly it was show there is no database fixup:the pathname 'd:\program files\lotus\domino\data\%1 was not found: file does not exist. any ideas to help to solve this matters

posted by Stephan H. Wissel on Monday 28 March 2011 AD:
@Skunk: you want help you need to follow the rules: valid working eMail!
Emoticon cool.gif

stw

posted by Eric Mack on Thursday 24 May 2012 AD:
Stephan, on the ncompact command, did you intend for the "c" to be lowercase? I see an uppercase "C" in the IBM documentation but I do not see a lowercase "c". Or, is that a secret command?

posted by Stephan H. Wissel on Thursday 24 May 2012 AD:
-c and -C are the same, one of the few parameters that are not case sensitive. See the technote: { Link }