Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 344
  • Last Modified:

Exchange database

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
yvonne2010
Asked:
yvonne2010
1 Solution
 
Glen KnightCommented:
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
 
yvonne2010Author Commented:
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
 
Glen KnightCommented:
No registry changes required, simply use Exchange System Manager, see here: http://support.microsoft.com/kb/821748
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
lloydclintonCommented:
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
 
Lee W, MVPTechnology and Business Process AdvisorCommented:
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
 
Glen KnightCommented:
Good point leew, however, as long as the mailboxes are all moved to the same database SiS should be retained.
0

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

Tackle projects and never again get stuck behind a technical roadblock.
Join Now