?
Solved

Question about Event ID: 9688 and the 75GB database limit on 2003 R2 STD

Posted on 2011-03-16
10
Medium Priority
?
944 Views
Last Modified: 2012-05-11
I'm getting the following description under Event ID: 9688

==============================================
Exchange store 'First Storage Group\Mailbox Store (SAPPHIRE)': The logical size of this database (the logical size equals the physical size of the .edb file and the .stm file minus the logical free space in each) is 67 GB. This database size is approaching the size limit of 75 GB.

If the logical database size exceeds the maximum size limit, it will be dismounted on a regular basis.
==============================================
(note: see attached Event ID Screen shot if needed)

BACKGROUND: I inherited this Exchange server.  As you can see the database size limits have already been extended to 75GB at some point in the past by a previous administrator.  I have asked the end users to delete any unnecessary email and permanently delete their deleted items folders, but I'm still getting the event 9688.

QUESTION: Is there a process I need to run on the database to "clean it up" so that the new database levels are recogniized or does this happen automatically after 30 days?       event id screen shot
0
Comment
Question by:voipguy
  • 4
  • 3
  • 2
  • +1
10 Comments
 
LVL 7

Accepted Solution

by:
waleeda earned 750 total points
ID: 35151374
0
 
LVL 4

Assisted Solution

by:prashant_sawant
prashant_sawant earned 750 total points
ID: 35151404
Please check the event id 1221, Which will give u the idea of white space available on the server..
0
 

Author Comment

by:voipguy
ID: 35151426
Contents of Event ID: 1221 from 3/15/2011:

The database "First Storage Group\Mailbox Store (SAPPHIRE)" has 125 megabytes of free space after online defragmentation has terminated.
0
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

 
LVL 7

Expert Comment

by:waleeda
ID: 35151443
no need for offline defrag its very small space
0
 
LVL 4

Expert Comment

by:prashant_sawant
ID: 35151637
So , The offline defrag of the database wont help you in compacting the size,

Firstlly you will have to ask all the users to download the mails from the exchange server, to local PST, this wil create a space on the server, i.e your your white space will increase, Also make sure that the retention policy is set to zero days for deleted items.

After you have finished with this,  check the ebvent id 1221 after online defrag , this will give u the exact space will you will get after performing the offline defrag.
0
 

Author Comment

by:voipguy
ID: 35151796
I agree with the steps recommended before performing an offline defrag, but I forgot to mention that there are no default storage limits defined in the Exchange server's Mailbox Store.  And as I perform a random survey of mailbox limits on end user accounts inside AD, I see there are none set there either; in fact, all end user account Storage Limits point back to the Mailbox Store defaults (of which there are none)

QUESTIONS:

Is the download of all mail to local .PST both a backup precaution as well as an effort to create white space.?

I will implement the Deletion setting retention policy changes against the store right away, but if I also set Storage limits now, will it cause any problems with the Exchange server's Mailbox Store or the end user's Outlook Client or should I wait until the work is completed with .pst creation before setting Storage limits as they may prohibiting sends as well as other work until the user account is cleaned up?.   Which is acceptable?

Is there someway to emty all "deleted items" folders in mass from all clients?
0
 
LVL 4

Expert Comment

by:prashant_sawant
ID: 35152445
downloading it to local pst means tht the mails will be no longer available on the server, As this will ceate a space on the server.
0
 
LVL 19

Expert Comment

by:R--R
ID: 35154804
The 1221 event does not contain the stm file. It only shows the edb free white space.
However if you want to check the actual while space of the database then you have to dismount the database and run eseutil /ms.

http://www.msexchange.org/articles/Exchange-Databases-Disk-Consumption.html

If you want to create more white space then purge th emailboxes which are already deleted and doenload the email to the pst.
0
 
LVL 4

Expert Comment

by:prashant_sawant
ID: 35356520
has the issue been resolved, expecting that it should be awaiting 4ur rply on this....
0
 

Author Closing Comment

by:voipguy
ID: 35752166
The question of setting storage limits causing any problems with the Exchange server's Mailbox Store or the end user's Outlook Client was not answered.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Steps to fix error: “Couldn’t mount the database that you specified. Specified database: HU-DB; Error code: An Active Manager operation fail”
Mailbox Corruption is a nightmare every Exchange DBA wishes he never has. Recovering from it can be super-hectic if not entirely futile. And though techniques like the New-MailboxRepairRequest cmdlet have been designed to help with fixing minor corr…
In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment. The video tutorial explains the basics of the Exchange server Database Availability grou…
This video demonstrates how to sync Microsoft Exchange Public Folders with smartphones using CodeTwo Exchange Sync and Exchange ActiveSync. To learn more about CodeTwo Exchange Sync and download the free trial, go to: http://www.codetwo.com/excha…
Suggested Courses
Course of the Month16 days, 3 hours left to enroll

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question