locked
Database size RRS feed

  • Question

  • hello,

    we have exchange 2007 sp2 with a 46GB mailbox database.edb  and 9GB tmp.edb. I have archived mail in all mailboxes but the size has increased from 40gb to 46gb. should I be concerned about this?


    `joe prior

    Saturday, October 6, 2012 7:38 AM

Answers

  • The database size never decreases on its own.  A 46GB database isn't anything to be concerned about.  So I can't say that you have anything to be concerned about.

    Ed Crowley MVP "There are seldom good technological solutions to behavioral problems."

    • Marked as answer by emma.yoyo Tuesday, October 16, 2012 2:35 AM
    Saturday, October 6, 2012 6:03 PM
  • Check the app event log and look for event 1221. That will tell you how much free space is avail in the database.

    After you remove a message from a mailbox, it retained in the dumpster for the set deleted item retention time that is defined at the database or mailbox level.

    • Marked as answer by emma.yoyo Tuesday, October 16, 2012 2:35 AM
    Sunday, October 7, 2012 2:48 PM
  • Hi Josh2009,

    Any updates?

    For more information about Event ID 1221, please see:

    Eseutil /D Defragmentation Mode

    http://technet.microsoft.com/en-us/library/aa997972(v=exchg.80).aspx

    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.


    Frank Wang

    TechNet Community Support

    • Marked as answer by emma.yoyo Tuesday, October 16, 2012 2:35 AM
    Monday, October 8, 2012 8:04 AM

All replies

  • The database size never decreases on its own.  A 46GB database isn't anything to be concerned about.  So I can't say that you have anything to be concerned about.

    Ed Crowley MVP "There are seldom good technological solutions to behavioral problems."

    • Marked as answer by emma.yoyo Tuesday, October 16, 2012 2:35 AM
    Saturday, October 6, 2012 6:03 PM
  • after archiving more mail the edb size is now 52gb. Can you tell me why reducing mailbox sizes cause the database to increase in size?

    `joe prior

    Sunday, October 7, 2012 2:37 PM
  • Check the app event log and look for event 1221. That will tell you how much free space is avail in the database.

    After you remove a message from a mailbox, it retained in the dumpster for the set deleted item retention time that is defined at the database or mailbox level.

    • Marked as answer by emma.yoyo Tuesday, October 16, 2012 2:35 AM
    Sunday, October 7, 2012 2:48 PM
  • Hi Josh2009,

    Any updates?

    For more information about Event ID 1221, please see:

    Eseutil /D Defragmentation Mode

    http://technet.microsoft.com/en-us/library/aa997972(v=exchg.80).aspx

    Please remember to mark the replies as answers if they help and unmark them if they provide no help. If you have feedback for TechNet Subscriber Support, contact tnmff@microsoft.com.


    Frank Wang

    TechNet Community Support

    • Marked as answer by emma.yoyo Tuesday, October 16, 2012 2:35 AM
    Monday, October 8, 2012 8:04 AM
  • event id report 99mb free after defrag. apologies I forgot to mention that I imported archived mail into various mailboxes before archiving again. This would explain the edb size increase. However, after archiving, the individual mailbox sizes are reduced, but the edb file has not. I see that it will not reduce on it's own but I would have expected a few gb at least of free space, not just 99mb.

    `joe prior

    Monday, October 8, 2012 2:14 PM
  • Not until the deleted item retention period, which is 14 days by default, expires because the content is retained in the "dumpster".

    Ed Crowley MVP "There are seldom good technological solutions to behavioral problems."

    Monday, October 8, 2012 3:01 PM
  • thanks for clarifying that. when I run the command Get-TransportConfig, the maxdumpstersizeperstoragegroup is 18mb. does this mean that only 18mb is stored in deleted items?

    can you also tell me what is the size limit for an exchange 2007 sp2 mailbox database.edb.


    `joe prior

    Monday, October 8, 2012 4:24 PM
  • That setting is not related. Check the properties of the mailbox database. That is where the deleted item retention time is set.

    THe size limit for Enterprise is "unlimited" . For Exchange 2007 standard, see:

    How to Modify a Database Size Limit

    Monday, October 8, 2012 4:49 PM
  • And it's a time, not a maximum size.

    Ed Crowley MVP "There are seldom good technological solutions to behavioral problems."

    Monday, October 8, 2012 11:01 PM
  • I have exchange 2007 standard and the database is 53GB. Will the database dismount if I don't increase the limit in the registry?

    `joe prior

    Tuesday, October 9, 2012 6:00 AM
  • I have exchange 2007 standard and the database is 53GB. Will the database dismount if I don't increase the limit in the registry?

    `joe prior

    Yes. There will be events in the logs warning that the database will be dismounted as well.

    Tuesday, October 9, 2012 11:07 AM
  • I have edited the registry to allow a 75GB limit. I would say there is a lot of unused space in the existing edb file so I am considering creating a new one and moving the mailboxes rather than an offline defrag which is risky I believe.

    `joe prior

    Wednesday, October 10, 2012 10:05 AM
  • I have edited the registry to allow a 75GB limit. I would say there is a lot of unused space in the existing edb file so I am considering creating a new one and moving the mailboxes rather than an offline defrag which is risky I believe.

    `joe prior

    The risk is low, but it requires downtime so moving the mailboxes to a new store is always recommended over doing an offline defrag.

    If this is the first database, restart the System Attendant service after removing the database to recreate the SA mailbox in the new store.

    Wednesday, October 10, 2012 11:01 AM
  • Agreed.

    And you can temp enable circular logging for both databases during the mailbox move otherwise large amount of Transaction Logs will be created.

    Understanding Transaction Logging

    http://technet.microsoft.com/en-us/library/bb331951(v=exchg.80).aspx


    Frank Wang

    TechNet Community Support

    Thursday, October 11, 2012 2:49 AM
  • But understand that doing so will impact your recoverability in the event of a failure.  Depending on your SLAs and tolerance for lost data, you may consider it a better option to run frequent backups to keep the log files truncated.

    Ed Crowley MVP "There are seldom good technological solutions to behavioral problems."


    Thursday, October 11, 2012 5:52 AM
  • Agreed.

    Enabling the circular logging is just for moving mailboxes at the moment.

    @Josh,

    Any updates?


    Frank Wang

    TechNet Community Support

    Friday, October 12, 2012 1:56 AM
  • will postpose creating a new edb file for the moment.


    `joe prior


    I have used a program called 'outlook true archive' to archive 2GB of mail in a mailbox. After online maintenance, I was expecting event id 1221 to show an increase in white space. but it has not. why would this be?
    • Edited by josh2009 Sunday, November 4, 2012 7:10 AM
    Saturday, October 13, 2012 11:31 AM