I’ve recently stumbled upon using compact -S5 in our weekly Saturday compact program document.
Like most shops, we run Fixup on Fridays and then Compact on Saturdays on all databases.
We found that a couple of servers that have about 400GB worth of mailboxes were not finishing their compact jobs. The compact was taking somewhere in the range of 36 to 48 hours. We weren’t sure how long it was taking because we had to shut it down on Monday morning when people got into the office and starting trying to access their databases.
I found the -S
