Link to home
Start Free TrialLog in
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.
ASKER CERTIFIED SOLUTION
Avatar of Will Szymkowski
Will Szymkowski
Flag of Canada image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of kbreitung
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.
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.
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.
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.