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.
kbreitungAsked:
Who is Participating?
 
Will SzymkowskiSenior Solution ArchitectCommented:
know i can just create a new mailbox/edb and move the address's to the new box but, i would lose the data

You will not lose data by creating a new Mailbox database and moving mailboxes from one database to another.

Is there a way with SQL I can move half the file out and keep half the database?

Exchange does not run on SQL. Exchange has its own Database Engine (ESE - Extensible Storage Engine)

Also if you are talking about growth are you referring to Logs? Exchange will continue to create logs on the server until a full backup is taken which at that point will purge the logs from the Logs directory.

1gb a day and growing. Unsure of how to proceed and keep relevant files based on timeline.
Best approach for databases is to keep them around 150-200GB. This allows you to have the flexibility for backups and restores times. Also it provides better performance when the database are smaller in size.

Also be aware that when you move mailboxes to another database the original database will not decrease in size. White space will be freed up when the Maintenance Schedule is completed but the actual size of the mailbox will not be smaller. This size does not change.

Will.
0
 
kbreitungAuthor Commented:
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.
0
 
Will SzymkowskiSenior Solution ArchitectCommented:
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.
0
 
kbreitungAuthor Commented:
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.
0
 
Will SzymkowskiSenior Solution ArchitectCommented:
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.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.