Database size

Hi,
We currently have 2 Exchange 2007 servers. Server A hosts the HT, CAS and MB roles and Server B hosts MB role only.  The plan is to move all mailboxes onto Server B. This process is almost complete.  This will leave a large empty MB Database/Storage Group.  We would still like to retain the mb db. Is there any way that this can be reduced in size, or removed and recreated. Space is an issue on this machine, which is what is driving the move.
Also, is it possible to install the remaining roles onto server b , but not have them active.
Any help would be appreciated.
Thanks
ZbiebuAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

AkhaterCommented:
once all mailboxes are moved to server B dismount the database in server A delete the EDB file and mount it again it will create you an empty

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
TheGeezer2010Commented:
You can always install the roles onto server B, but to make them inactive makes no sense since they provide natural redundancy and load balancing. I think you will run into trouble if you (for example) stop the transport service on the HT server, but what you CAN do is to suspend the queues on it, this way it will not be used for any mailflow internal or external (it would only be used external anyway if you had added it in as a HT source for your external connector). As a CA server, it would only be used if the external FQDN pointed to it via DNS, otherwise it will only be used for internal  OWA etc.

HTH
mrklaxonCommented:
Delete and recreate is probably easiest.  If not comfortable with that then do offline defrag:
Eseutil.exe /D
http://technet.microsoft.com/en-us/library/aa997972(EXCHG.80).aspx
This clears free space and shrinks the DB but involves rebuilding it and needs free disk space to build the temp DB.
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

R--RCommented:
Yes mrklaxon is correct defrag the database if you want to retain the same database.
You can install the CAS and HT on server B and stop the hub transport service and cas services.
AkhaterCommented:
if the db is empty there is no point in defrag, let him just delete and recreate it
ZbiebuAuthor Commented:
Thanks to all for the responses.  The long term plan is to replace Server A and have everything running on Server B.  I would like to shrink the DB on Server A as a short term measure to allow more room for the queue.
Thanks
Rajith EnchiparambilOffice 365 & Exchange ArchitectCommented:
Though you move all users to server b, the database size wont decrease because of the white space. You can do an offline defrag or delete the DB and recreate it.

If you have a load balancer, then make sure that you don't include server B for load balancing, that way you can have a "kind of" standby server. Or else install the roles and stop the services.

Why do you want to do it anyway?
AkhaterCommented:
Just follow what i told you in the first reply for that question, move all mailboxes, dismount the db, delete the edb file and mount it again that's it
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Exchange

From novice to tech pro — start learning today.