locked
Database size is approaching the size limit of 75 GB RRS feed

  • Question

  • Hello support,

    Exchange 2003 SP2.

    We are getting an Event ID: 9688 because the .edb and the .stm is 70GB. I've read that 75gb is an license limit, when reached the Mailbox Store while be dismounted. Is there a way to change the size limit of 75GB? Possible solutions: 1. AutoArchive and offline defragmentation 2. upgrade to Exchange 2007 so I can create 5 databases. Are there any other options? Kind regards.


    Kind regards.

    Thursday, April 7, 2011 9:22 AM

Answers

  • Only on enterprise.  Which, if you had, you wouldn't be having this problem in the first place, so disregard my previous post! 

    Your best options are like Joe said, do an offline defrag. 

    If it isn't feasable for you to upgrade exchange I would impose quotas on users to help manage the space and get them to delete crap.  I personally have it set that any items over 3mb are permantly deleted after two weeks.  If it's important, save the attachment and delete the email.  If they complain, tell them it's the limitation of the software.  That may make it easier for you to get the funds to upgrade exchange. :)  But like Rip said, don't do it without a plan...

    Thursday, April 7, 2011 8:16 PM

All replies

  • Hello,

     

    Limit of 75GB db size in Exch2003 can only be increased a bit in case of limit is reached to be able to mount the store in way to resolve the issue. This limit is only on Standard edition of Exchange 2003R2.

    So, to continue working with this version the only way is to archive old email out of the db.

    If you plan to upgrade, Exch 2003ENt, Exchange 2007, Exchange 2010. you won't have this limitation...

    However, be sure to buy the right version to your needs, and migration to Exch 2007, 2010 should no be done in a hurry without any plan...

    BR.


    RipPle
    Thursday, April 7, 2011 9:38 AM
  • Thank you for your information RipPle.

    Is there documentation available for setting up AutoArchibe through group policy, we use Outlook 2003.
    I've already installed the Office Resource Kit and settings can be made for the AutoArchive and Retention settings.
    I did read on the Internet that PST files don't belon on a fileserver but local.

    I just enabled the settings through group policy but the settings are only enabled on inbox and not on the subfolders, in Outlook 2003 there is the following setting 'apply these settings to all folders now', where can i find this in the group policy?


    Kind regards.
    Thursday, April 7, 2011 9:56 AM
  • Hi,

    You can add the outlook .adm to your Gpo's and you'll be able to create a gpo that customize quite deeply outlook clients.

    Here is the Outlook 2003 adm file download link:

    http://support.microsoft.com/kb/885682 (it includes how to use it)

    Kind Regards


    RipPle
    Thursday, April 7, 2011 6:29 PM
  • What about creating a second storage group and splitting the mailboxes between the two groups?
    Thursday, April 7, 2011 7:09 PM
  • Dismount the database and run the command

    eseutil /ms "database path \database file.edb"

    find out the white space or go to the event viewer and find the event id 1221

    if database has much freespace, run the command

    eseutil /d "database path \database file.edb"

     

    http://support.microsoft.com/kb/259851


    Thanks Joseph Pradeep
    Thursday, April 7, 2011 7:15 PM
  • What about creating a second storage group and splitting the mailboxes between the two groups?

    Is that possible with Exchange 2003?
    Kind regards.
    Thursday, April 7, 2011 8:06 PM
  • Dismount the database and run the command

    eseutil /ms "database path \database file.edb"

    find out the white space or go to the event viewer and find the event id 1221

    if database has much freespace, run the command

    eseutil /d "database path \database file.edb"

     

    http://support.microsoft.com/kb/259851


    Thanks Joseph Pradeep

    thank you, didn't no the /ms switch.
    Only did not get the event id 1221, but in the CLI after the eseutil /ms was finished, the number 25072 is shown.
    Can you tell me how much freespace this is? 

    Thursday, April 7, 2011 8:15 PM
  • Only on enterprise.  Which, if you had, you wouldn't be having this problem in the first place, so disregard my previous post! 

    Your best options are like Joe said, do an offline defrag. 

    If it isn't feasable for you to upgrade exchange I would impose quotas on users to help manage the space and get them to delete crap.  I personally have it set that any items over 3mb are permantly deleted after two weeks.  If it's important, save the attachment and delete the email.  If they complain, tell them it's the limitation of the software.  That may make it easier for you to get the funds to upgrade exchange. :)  But like Rip said, don't do it without a plan...

    Thursday, April 7, 2011 8:16 PM
  • Hi,

    You can add the outlook .adm to your Gpo's and you'll be able to create a gpo that customize quite deeply outlook clients.

    Here is the Outlook 2003 adm file download link:

    http://support.microsoft.com/kb/885682 (it includes how to use it)

    Kind Regards


    RipPle
    Did that already, but there is no option to apply these settings to all subfolders.
    Kind rega
    Thursday, April 7, 2011 8:24 PM
  •  I personally have it set that any items over 3mb are permantly deleted after two weeks.
    Can this be done with a group policy?
    Kind regards.
    Thursday, April 7, 2011 8:53 PM
  • No, create a Recipient Policy in the Exchange System Manager:

     

    Start System Manager > Recipients.  Right Click Recipient Policies/  Click New >Recipient Policy.  Click the box for Mailbox Manager Settings.  Name it on the General Tab.  Then on Mailbox manager tab, select the folders, Age and size you want to apply it to.  Change the drop down to Delete immediately or whatever you want.  After you configure and save the policy, you schedule it to run by right clicking the server under the Storarge Group and going to properites.  Click Mailbox Management.  Set the time of when you want it to run.  I recommend under reporting to send to the administrator and set yourself as the administrator.  It will show you how much was freed per mailbox and overall.

    Thursday, April 7, 2011 9:07 PM
  • No, create a Recipient Policy in the Exchange System Manager:

    Start System Manager > Recipients.  Right Click Recipient Policies/  Click New >Recipient Policy.  Click the box for Mailbox Manager Settings.  Name it on the General Tab.  Then on Mailbox manager tab, select the folders, Age and size you want to apply it to.  Change the drop down to Delete immediately or whatever you want.  After you configure and save the policy, you schedule it to run by right clicking the server under the Storarge Group and going to properites.  Click Mailbox Management.  Set the time of when you want it to run.  I recommend under reporting to send to the administrator and set yourself as the administrator.  It will show you how much was freed per mailbox and overall.


    Thank you.
    Kind regards.
    Friday, April 8, 2011 6:22 AM
  • Didn't no the eseutil /ms switch.
    Only did not get the event id 1221 in the eventviewer, but in the CLI after the eseutil /ms was finished, the number 25072 is shown.
    Can you tell me how much freespace this is? Is this in KB?


    Kind regards.
    Friday, April 8, 2011 6:23 AM
  • Only did not get the event id 1221 in the eventviewer,

    Hi ZX7R,

    Please check whether the online defragmentation is performed or not.

    Cannot determine free space available in Exchange database

    http://support.microsoft.com/kb/186291

    About the eseutil /ms, please see:

    Determining the True Amount of Space in an Exchange Database
     
    Frank Wang

    TechNet Subscriber Support in forum

    If you have any feedback on our support, please contact tngfb@microsoft.com  


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Friday, April 8, 2011 9:12 AM
  • Hi ZX7R,

    Any updates?


    Please remember to click “Mark as Answer” on the post that helps you, and to click “Unmark as Answer” if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.
    Monday, April 11, 2011 3:16 AM
  • Yes, solved this issue with AutoArchive and Defrag, now database is 55GB.

    Now i'm planning to upgrade to Exchange 2010.

     


    Kind regards.
    Monday, April 11, 2011 6:48 AM
  • Have you thought about splitting the database into two smaller databases?
    Wednesday, April 13, 2011 8:37 PM
  • Have you thought about splitting the database into two smaller databases?

    How is that possible with Exchange 2003?
    Kind regards.
    Thursday, April 14, 2011 6:11 AM
  • Try setting a lab on Exchange 2003 first. Create two storage groups and place a DB on each. Don't know if licensing would prevent you from doing this. Besides, Exchange 2007 has better features. So I think it's time to upgrade.
    Thursday, April 14, 2011 1:09 PM
  • Try setting a lab on Exchange 2003 first. Create two storage groups and place a DB on each. Don't know if licensing would prevent you from doing this. Besides, Exchange 2007 has better features. So I think it's time to upgrade.


    Did you read the post?

    We use Exchange 2003 std, it's not possible to create 2 storage groups!


    Kind regards.
    Friday, April 15, 2011 7:46 AM
  • If you cannot create two DBs into that storage group, then you don't have any option but upgrade to Exchange 2007.
    Monday, April 18, 2011 2:20 PM
  • I agree with PHE .. I have one user mail box size about 16 GB and Guess what he's the firm CEO after several try to convince him to delete his old e-mails, which's already  been archived.

     

    I had NO success.. My end result was as PHE said software limitation in 2003 or upgrade to 2007 or 2010. After that we deleted some old e-mail.  My question is if some know .edb & .stm database remain the same size which’s 216 GB even though I archived e-mail and delegated the mail box those people no longer at firm. My question how to reduce to size? The Exchange we have is Ent 2003 on EMC SAN FC-Lun.


    IT DIRECTOR
    Monday, November 14, 2011 4:56 PM