Exchange 2010 defraf database not releasing space

I have Exchange 2010 with the default database. It got to over 180 gig. I created another database and moved a lot of user. I successfully  ran a defrag on the first database however it is still 180 gig. When I check white space it shows a total of 812 meg. Currently there are only 10 mailboxes on there and they are small.

How can I shrink that database?
Who is Participating?

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

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.

AmitIT ArchitectCommented:
Just move all user to new DB. Delete and create fresh one.
ajdratchAuthor Commented:
I thought about doing that. I just worry that it could break something and if I delete it, I can't get it back. Is there any possible issues I could come across by deleting that one?
AmitIT ArchitectCommented:
Once all mailboxes are moved to new DB. Then you won't face any issue.  In case this is first DB. Then you might need to follow my article.

If you have Public Folder, make sure you new DB is also pointing to PF DB. Rest I don't see any other risk.
Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

ajdratchAuthor Commented:
Thanks for that link. I have never deleted the first mailbox because I was afraid of possible issues. I would still prefer to keep this one instead of going through all those steps if possible. Any idea why a defrag would not shrink the database>
AmitIT ArchitectCommented:
FYI Defrag db also create new DB. So you already created a new DB, that old DB is already gone. With my article, you can delete this DB without any issue. Still you feel risky. You can leave this and create new DB's. However, I don't see any risk in deleting and recreating it again.
Simon Butler (Sembee)ConsultantCommented:
The first database does have some system mailboxes in it - but those can be easily moved and Exchange will not let you drop the database if it is being used.

Offline defrag is a waste of time with Exchange 2010 - you should have just deleted the database instead.

ajdratchAuthor Commented:
I get that defrag creates a new one but it is supposed to overlay the old one. If it did not overlay it, where would it be? I assume I could manually do that?
Simon Butler (Sembee)ConsultantCommented:
An offline defrag will create a new database using the old content.
The old mailboxes are probably still retained due to deleted mailbox retention within the database - although I am not sure if that does survive an offline defrag because I haven't done one since Exchange 2007 was released. Complete waste of time in my opinion.

I would just forget about why it is happening, drop the old database and create a new one.


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
AmitIT ArchitectCommented:
Now you have advise from me and Simon and we both recommend you right solution. Now you can review and decide.
ajdratchAuthor Commented:
When I saw "mailbox "retention"  I realized that was probably the issue. I changed the retention settings to 0, re-ran defrag and shrunk the database completely. Next I will back that up and go through the process of removing the first mailbox store
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

From novice to tech pro — start learning today.