Solved

How to reduce the Exchange mailbox database partition size

Posted on 2011-03-23
13
1,335 Views
Last Modified: 2012-05-11
Hi All,

I just got a growing problem in my Exchange Server 2007 SP1 CCR mailbox server role, the free space is getting lesser and lesser every week and now it has reach 20% low

I've separated the transaction log partition already (per storage group per partition) and now they're fine

I have moved the top 2 mailbox in this DB partition but somehow it is still not decreased ?

any help and suggestion would be greatly appreciated.

Thanks
0
Comment
Question by:jjoz
  • 5
  • 3
  • 2
  • +3
13 Comments
 
LVL 3

Expert Comment

by:jodix2002
Comment Utility
0
 
LVL 11

Expert Comment

by:FastFngrz
Comment Utility
Shrinking a database file is an offline edbutil command, please make sure you have a good backup before taking the IS offline! Somewhat risky, cause you need 1.5xdatabase size free disk to do the defrag. It can be on another disk if needed.

Although, with whitespace now in the database (by you moving mailboxes/mail out of that store) should allow it to fill out without allocating more disk.  Did you see your disk utilization slow/stop after the move?
0
 
LVL 4

Expert Comment

by:andrewglendean
Comment Utility
follow this link
http://www.petri.co.il/defragment_exchange_2000_2003_server_databases.htm

databases for which exchange mail store are one don't shrink automatically when items are deleted. They are referred to as white space.

White space are areas that can be over written.

By following the link provided your can compact the database by removing the white space areas. but you will need 110% free space somewhere before you run the tool.

0
 
LVL 1

Author Comment

by:jjoz
Comment Utility
oh, so in this case no matter how many mailboxes that I migrated from this storage group, I will always get that 90%+ full ?
0
 
LVL 3

Expert Comment

by:jodix2002
Comment Utility
no...
what to do:
- archive mailboxes using exmerge, if necessary
- do an offline defragmentation
its there on the link i gave you.
0
 
LVL 49

Expert Comment

by:Akhater
Comment Utility
do not do offline defrag unless absolutely needed it is useless and will lead to down time

please keep in mind that the DB will be offline during the whole defrag period which might be quite long if you have a big db

1. There is no need to defrag, the edb file size is the same but your edb has whiite space, so the edb file size will not grow untill all this white space is consumed
2. to do offline defrag you need 110% of the db size on free space


the correct way to do it is

1. create a totally blank db
2. move all your mailboxes to the new db
3. delete the old db

this way you have

1. no downtime (a part from the user being migrated)
2. less space required since it requires only the size of the new db and not 110% like in defrag
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 1

Author Comment

by:jjoz
Comment Utility
thanks Akhater,

so in this case i should:

1. create storage group in separate partition
2. create email DB
3. migrate all of the mailboxes out of the office hours into the new storage group.
4. after that it can be safely deleted.

I am afraid that If I don't do something quick it will run out of disk space and the email will be stopped working.
0
 
LVL 49

Accepted Solution

by:
Akhater earned 333 total points
Comment Utility
first you don't have to worry now about the space since you will be using the db white space. This being said having a db running on a disk that is 90% full is indeed dangerous


1. create storage group in separate partition
2. create email DB
3. enable circular looging on both storage groups
4. migrate all of the mailboxes out of the office hours into the new storage group.
5. after that it can be safely deleted the old mailbox db and storage group
6. disable circular logging
7. if needed move back the new db (now defraged) to the other partition
0
 
LVL 1

Author Comment

by:jjoz
Comment Utility
wow that does sounds like a plan Akhater :-)


7. if needed move back the new db (now defraged) to the other partition --> so after all of the mailbox migrated to the new database I need to dismount and then manually copy using Windows Explorer for both Log files and the .EDB
0
 
LVL 49

Assisted Solution

by:Akhater
Akhater earned 333 total points
Comment Utility
no you do not move them manually

1. on the storage group right click you have an option to move log files and system filles
2. on the mailbox database right click you have an option to move the edb file

and yes the mailbox db will be dismounted during the move operation
0
 
LVL 1

Author Comment

by:jjoz
Comment Utility
ah yes, through EMC I can see Move-Database path :-o)
0
 
LVL 31

Assisted Solution

by:MegaNuk3
MegaNuk3 earned 167 total points
Comment Utility
Also look in your application event logs for the 1221 event which will show how much whitespace you have in your databases, then you can decide if you even need to do anything.
0
 
LVL 1

Author Closing Comment

by:jjoz
Comment Utility
many thanks for your guidance guys I really appreciate it.
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Local Continuous Replication is a cost effective and quick way of backing up Exchange server data. The following article describes the steps required to configure Local Continuous Replication. Also, the article tells you how to restore from a backup…
This process describes the steps required to Import and Export data from and to .pst files using Exchange 2010. We can use these steps to export data from a user to a .pst file, import data back to the same or a different user, or even import data t…
This tutorial will walk an individual through the steps necessary to configure their installation of BackupExec 2012 to use network shared disk space. Verify that the path to the shared storage is valid and that data can be written to that location:…
This tutorial will walk an individual through the steps necessary to join and promote the first Windows Server 2012 domain controller into an Active Directory environment running on Windows Server 2008. Determine the location of the FSMO roles by lo…

728 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now