Hello All,
I having problems when my users are attempting defragmentation on their laptops. When the laptop completes with defragmenting, the report views some files which could not be defragmented. The files are notes dataases.
I attempted to run, in the dos prompt, ncompact and then nfixup. This didn’t help.
Is there a way I can assure that I get a complete defragmentation?
In advance, Thank you for your help
Subject: Defragmenting Database on Client
Jason,
It could be an issue with available space on yout clients laptop and the size of the database. For instance if you have a 2.4gb database and less than 10% of the partition space left. The defragger (if it’s the windows xp built in one) cannot effectively re-cluster the blocks.
Personally, what I do is, clear my internet temp files (which has a lot of downloaded junk and cached stuff), clear all my temp files, empty the recycle bin. I then compact my data folder (just like you did by running ncompact from a prompt). Then I run the defragger.
I have had problems when I don’t have much space to work with. If you are really pressed to see if you can get it do defrag you can try deleteing the view indexes and then try it. Although end users hate this as they then have to wait for views to build when then need them (and end uses hate to wait 
)
Mike Robinson
Subject: RE: Defragmenting Database on Client
Hi Michael,
Thanks for the tip. I will try this and see what happens. :o)
Subject: Defragmenting Database on Client
Have you tried a copy-style compact (no access option)?
Subject: RE: Defragmenting Database on Client
Hi Stan,
What I did was go into a dos prompt, and just typed ncompact with no options. I assume you mean that?