Database off-line defrag

Posted on 2011-10-14
Medium Priority
Last Modified: 2012-05-12
Total size 49.9
Free Space 6.49

Event Type:      Warning
Event Source:      MSExchangeIS Mailbox Store
Event Category:      General
Event ID:      9685
Date:            10/14/2011
Time:            7:48:51 AM
User:            N/A
The current physical size of this database (the .edb file and the .stm file) is 52 GB. This database has exceeded the size limit of 48 GB. However, the logical free space in this database has not yet been evaluated. Therefore, it is possible that this database contains enough free space to bring its logical size below the maximum size limit.

If the logical database size exceeds the maximum size limit, it will be dismounted on a regular basis.

We have been running Mailbox Management Process to clean deleted and old e-mail messages based on the Mailbox Manager Settings Policy; however,  I think, there is a lot of white space.  In addition, the disk space on the server is  limited.  What is the best way to resolve this issue?
Question by:denverha
  • 2

Expert Comment

ID: 36969926
If disk space is limited on the server you may struggle to do an offline defragment as it needs to create a tmp database which will be the same size. I have had great success with offline defrag's so if you have the space then its the best way to go. The mailbox management process I have found in no way compensates for a full offline defrag. I would increase the database size to give you some breathing space as a store dismounting should be avoided.

Author Comment

ID: 36969962
How about mapping a drive from different server and then peform the defrag.

Accepted Solution

maytrix earned 2000 total points
ID: 36970159
Mapping a drive would work, but if there is a network issue that can cause problems.  I'd use a local USB drive before I'd use a mapped drive.

Author Closing Comment

ID: 36970236
Thanks for your help

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Backups and Disaster RecoveryIn this post, we’ll look at strategies for backups and disaster recovery.
How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

840 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