Avatar of kbreitung
kbreitung
 asked on

EDB files and SQL

I am not an exchange admin. I am running a 2008 r2 server with exchange 2010. My data HDD on the server(Exch/Mailbox/) is taking up all the space with multiple mailbox's having huge EDB files. I used exchange management shell to show the mailbox and which is under each edb. All mailbox's have huge journal files like you would expect. My question... I know i can just create a new mailbox/edb and move the address's to the new box but, i would lose the data. Is there a way with SQL I can move half the file out and keep half the database? possibly by date to a server i set up as say an archive mail server ? how could i do this with SQL. Is it possible there is a walk through for this ? My server has started to slow down considerably now that I have less and less space remaining. It is typically collecting around 1gb a day and growing. Unsure of how to proceed and keep relevant files based on timeline. Nightly backups are preformed on site and daily backups are preformed and taken off site.
ExchangeEmail Servers

Avatar of undefined
Last Comment
Will Szymkowski

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Will Szymkowski

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
kbreitung

ASKER
Sorry for my confusion. How is there a way to create an archive server then with old messages and remove these old messages from my current database to free up space on the servers data drive.
Will Szymkowski

If you do not have an Archiving solution in place, then all you will be able to do is create a new drive and have your users save PST's to this location (this is not a preferred method).

Also when you are archiving data from mailboxes the ACTUAL mailbox size does not shrink, it stay's the same. You do free up whitespace after maintenance has run but the actual logical size of the database will not be reduced.

The only way to free up space would be to create new databases on another Drive on the server, Move ALL of the mailboxes to the new databases and then delete the EDB file once they have all been removed.

Will.
kbreitung

ASKER
So i create a new database move the mailboxes over to the new database and then delete the old EDB file. This may be a stupid question but if they back up the PST file and then this is done it will still have the files they saved in folders once they reimport the PST file on the new database.
Your help has saved me hundreds of hours of internet surfing.
fblack61
Will Szymkowski

Personally I would not be doing this exporting to PST, and then importing them into a new database. Moving the mailbox is the most efficient way, this also ensures that nothing is missed and the mailbox is automatically accessible after the move have been completed.

This may be a stupid question but if they back up the PST file and then this is done it will still have the files they saved in folders once they reimport the PST file on the new database

I think you have misunderstood me, if the users export their mailboxes to PST there mailbox will be smaller, yes but the overall size of the actual Database will not be changed.

Will.