I ran compact -B on a users mail file after she deleted a large amount of mail. But whe I look at the file size on the server it has not changed. Can someone tell me why, or did I run the wron command?
Software/Hardware used:
ASKED:
October 20, 2008 2:51 PM
UPDATED:
October 24, 2008 2:32 PM
Isn’t -c for corruption probelms. My mail file is not corrupt?
-c does a copy of the database, and that is how it reduces the size. -B should also work, do your logs show an error after you ran the command? If someone accessed it while it was compacting, then it would have stopped and not completed. If you run this in the middle of the night when it is unlikely anyone will be accessing the database, the -B will most likely work. Any other time, or when you cannot be certain a user will try to access it, use -c (you can add -L if you want to allow access during compact, but it may not work perfectly) and access will be restricted during compact. You are right though, that it will clear corruption as well, but -c stands for COPY.
We always use compact – B on all out databases and have it run once a week in the middle of the night. As SlikTool said, check your log. It does reduce the size if it completes.