SBS 2003 Database Consolidation
Posted on 2010-01-06
I have a client whose Exchange 2003 database is growing out of control. They are currently at about 50 GB, which is a lot considering there are only 5 people in the office. The issue is they are architects and need to email large files back and forth to clients. They always copy other workers in the office and due to the letigious nature of the business they must keep ALL emails. As you can imagine with multiple copies of the same large files floating around things got out of control.
We've since implimented an archiving system which requires all users to move project related emails into public folders. Once the projects are done the specific public folder is archived and removed from Exchange all together.
The issue is the scheduled online defrag of the database does not remove any whitespace, therefore despite massive reductions in mailbox size the overall database size remains the same. I have tried an offline defrag of the private databases, but despite doing this the size of the database stayed the same. Below is the command prompt I used:
c:\program files\exchsrvr\bin\eseutil /d d:\exchsrvr\mdbdata\priv1.edb /b c:\priv1_bak.edb
It created the backup on c: which was the original size and the "defragged" database is int he original location the exact same size. With help from a guru I found event ID 1221 and discovered the whitespace was only 2 MB. We adjusted the maintenance period and set the deleted mailbox save period to 0. After waiting a couple hours event ID 1221 reported 17 GB free. I ran the same command line again but got this error.
C:\Program Files\Exchsrvr\bin>eseutil /d d:\exchsrvr\mdbdata\priv1.edb /b c:\pri
Microsoft(R) Exchange Server Database Utilities
Copyright (C) Microsoft Corporation. All Rights Reserved.
Initiating DEFRAGMENTATION mode...
Streaming File: d:\exchsrvr\mdbdata\priv1.STM
Temp. Database: TEMPDFRG8656.EDB
Temp. Streaming File: TEMPDFRG8656.STM
Defragmentation Status (% complete)
0 10 20 30 40 50 60 70 80 90 100
Operation terminated with error -1014 (JET_errOutOfBuffers, Out of database page
buffers) after 15210.828 seconds.