Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Exchange database

Posted on 2011-03-03
6
Medium Priority
?
343 Views
Last Modified: 2012-05-11
Hi There,
we have an exchange 2003 server in a clustered environment. database is extremely large and my client would not agree to a downtime for an offline defrag. database is 300gb.(yeah i know. i inherited it like that). My question is this,
1)Can i move the mailboxes temporarily,to a different store,delete the database, create a new one and move mailboxes back?
2) would this reduce the size of the DB?
3) What would be the implications ie log files, data loss etc?
4) i assume i would need to do a backup immediately after this is done?
5) Would i need to move the logs as well and would they still be useful afterwards?
6) which log files would be required if any?
Thanks a million and apologies in advance for ignorance.
0
Comment
Question by:yvonne2010
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 74

Expert Comment

by:Glen Knight
ID: 35026173
Yes, moving mailboxes to another database will reduce the size as whitespace is not copied to the new database.

A backup should be performed before and afterwards, you don't need to do anything with the logs, the new database will have it's own set of logs.

Also checkout my guide here: http://www.experts-exchange.com/Software/Server_Software/Email_Servers/Exchange/A_2730-Exchange-Offline-Defrag.html
0
 

Author Comment

by:yvonne2010
ID: 35027303
Thanks a lot for that.
 i also would like to know how to (Steps to create a new DB) create a new DB. would i need to edit the registry and give rights/permissions to groups ie system,administrators etc for the new DB folder?
Thanks
0
 
LVL 74

Expert Comment

by:Glen Knight
ID: 35027324
No registry changes required, simply use Exchange System Manager, see here: http://support.microsoft.com/kb/821748
0
Does Powershell have you tied up in knots?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

 
LVL 3

Expert Comment

by:lloydclinton
ID: 35027629
Also, do you have storage quotas for the mailboxes?  If not, I would talk to them about it.  Many companies inadvertently use MS Exchange as a file server and media transport server.  That is why we many times see such large information stores, and you as well as I know how long it would take to recover a server with a 300gb information store!  You could also talk to them about archiving.  We have Exchange 2007 and use a Barracuda message archiver and it has allowed us to optimize our server for performance and longevity.  
0
 
LVL 96

Expert Comment

by:Lee W, MVP
ID: 35032922
Demazter, correct me if I'm wrong, while doing this SHOULD clean up the white space, it will in a sense kill single instance storage since moving a mailbox will create make each message an actual message.  Though unlikely, it IS TECHNICALLY POSSIBLE that the database would GROW doing this... right?
0
 
LVL 74

Accepted Solution

by:
Glen Knight earned 1000 total points
ID: 35033033
Good point leew, however, as long as the mailboxes are all moved to the same database SiS should be retained.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Unified and professional email signatures help maintain a consistent company brand image to the outside world. This article shows how to create an email signature in Exchange Server 2010 using a transport rule and how to overcome native limitations …
Are you an Exchange administrator employed with an organization? And, have you encountered a corrupt Exchange database due to which you are not able to open its EDB file. This article will explain all the steps to repair corrupt Exchange database.
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…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…

704 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