Manage Learn to apply best practices and optimize your operations.

Repair local databases on desktop

This tip explains how to use nfixup and ncompact to repair local DBs on a desktop such as PAB and a local archive.

View member feedback to this tip.

Local databases on the user's desktop such as personal address book and local archive sometimes become corrupted and require repair.

There are "command prompt" versions of the server database maintenance utilities (Fixup, Updall and Compact) available to repair local databases.

The local tools are nfixup.exe, nupdall.exe and ncompact.exe. The Notes desktop client install includes nupdall.exe but not the other two. Nfixup and ncompact are found in the Domino folder on the server. They fit on a floppy disk and may be copied into the user's LotusNotes folder to run at the desktop.

Here's how:

  1. Close all running applications, including Notes.
  2. Go to Command prompt in folder LotusNotes> (this is your "live console" on the local PC).
  3. At the Command prompt LotusNotes>, enter these commands and switches in the following order:
    1. (Enter the user's Notes password when prompted)
    2. nfixup c:lotusnotesdata(filename)
    3. nupdall -r c:lotusnotesdata(filename)
    4. ncompact c:lotusnotesdata(filename)
  4. Do not start the next command until you see that the previous command has shut down. Type Exit to return to Windows.


The nupdall command syntax should be "nupdall c:lotusnotesdata(filename) -R" and not "nupdall -r c:lotusnotesdata(filename)." The -R should be at the end, otherwise it will run on all databases instead of just the specified one.

—Ninad L.

Do you have comments on this tip? Let us know.

This tip was submitted to the tip exchange by member Karen Shumaker. Please let others know how useful it is via the rating scale below. Do you have a useful Notes/Domino tip or code to share? Submit it to our monthly tip contest and you could win a prize and a spot in our Hall of Fame.

Dig Deeper on Lotus Notes Domino Database Management



  • Favorite iSeries cheat sheets

    Here you'll find a collection of valuable cheat sheets gathered from across the iSeries/ community. These cheat ...

  • HTML cheat sheet

    This is a really cool cheat sheet if you're looking to learn more about HTML. You'll find just about everything you every wanted ...

  • Carol Woodbury: Security

    Carol Woodbury