Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17


Is it possible to extract all Attachements from Exchange 2003 and save them somewhere else?

Posted on 2011-02-25
Medium Priority
Last Modified: 2012-05-11
Good day,

My exchange database is becoming huge, and i do not have unlimited  space on my server.  I have less than 10% disk space free. I can clear up some space easily, but for Exchange,  I'd like to be able to reduce the  database size  considerably.

I thought of doing an offline defrag,  (never done it)  but im not confident on defrag technologies with corporate emails on an old  SBS 2003 server.  I know its possible to extract all the attachements from LOTUS Notes,  but  I dont know if its possible with Exchange 2003.

What would be the best thing for me to do?  Is it really safe to make an offline defrag on my Exchange 2003 database? (about 30GB in sice) Priv1.edb is 23GB in size and priv1.stm is 8.8 GB in size.

Question by:maxalarie
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +1
LVL 27

Expert Comment

ID: 34982703
I'm not aware of that option.
Except buying more disks and move exchange database there, I would suggest that you change the value of "retain deleted items" to 0 days and instruct users to archive old mails to local PST files. Then set the mailbox limits to lower value. Next day you can again change the value of "retain deleted items" to 7 or 14 days.
On exchange online defragmentation is done every night. Offline defrag will not save you additional space.

Expert Comment

by:Acosta Technology Services
ID: 34982880
Offline defrag is safe as long as you have a good backup and 110% free space (110% of edb+stm).  Check event #1211 in the Exchange Server's application log to find out how much space you'll free up.  Event should occur before 7am each day.

Author Comment

ID: 34982938
Ok, Thanks you. I do not have that much space left on the server at the moment.
Thanks for the help.
Office 365 Training for IT Pros

Learn how to provision tenants, synchronize on-premise Active Directory, implement Single Sign-On, customize Office deployment, and protect your organization with eDiscovery and DLP policies.  Only from Platform Scholar.

LVL 27

Assisted Solution

davorin earned 1000 total points
ID: 34984496
Sorry. I don't know what I was thinking about, while I was writing my last sentence...
Offline defrag does reduce size of DB on disk by removing whitespace from DB.
Two interesting links:
LVL 17

Accepted Solution

lucid8 earned 1000 total points
ID: 34988197
1. If you want to pull out attachments to make the DB smaller you would be looking at an Archive system  that would archive the attachments and larger bodies etc into an archive server.

2. Even if you deploy an archive server the only way to get the DB to be physically smaller is to run and offline defrag and then run an Isinteg until you have zero (0) errors repaired (i.e. you usually have to repeat the isinteg command multiple times)

3. One of the other members mentioned to look for a event 1211, and that is incorrect, you want o look for event 1221 and here is a good article for you and if you don't see that you are going to gain a bunch of space back you may not want to do a defrag.  That said it could be that your users have not emptied their deleted items folders and if that the case you can appeal to them to do so, as well as to get rid of items they truly don't want and then continue to monitor the 1221 events until you feel its worthwhile to run a defrag.

4. it is possible to run an Eseutil /D against a database if you don't have the 110% space available on your server, i.e. you can tell it to use the space on an alternate machine that has enough space (Still 110% ).  The downside of course is that the defrag will take longer to do since you are involving a drive on an alternate machine.  Here is another great article for you to read and this is a good read as well  in short you would do the following

A. Map a drive to a machine that has the 110% of disk space free (For this example lets assume you use drive F: when you do the mapping

B. Take the database offline

C. Backup the database while its offline to tape or disk, i.e. never run  any command against the only copy of the database you have

D:  Open a command prompt and change to your Exchsrvr\bin

NOTE: I am making certain assumptions with the below syntax, i.e. that your DB is in the path used below, but if not then change accordingly
E: Run Eseutil /d “c:\program files\Exchsrvr\mdbdata\priv1.edb” /tF:\defrag\tempdfrg.edb

5. Once your defrag is complete you need to run ISINTEG command  of " c:\program files\exchsrvr\bin>isinteg -s ServerName -fix -test alltests"  see more about it here  There are a few very important things you needs to be aware of;

A: Isinteg doe NOT need the 110% free space, i.e. it works in place
B: When you run the command you need to be very patient since it can take a very long time to run and sometimes you will swear nothing is happening but it is working away
C: you will more than likely need to run this command multiple times, i.e. rule of thumb is to run this command until it reports Zero (0) errors repaired and this usually takes a minimum of two passes.

6. Bring the store back online and do a quick check to ensure everything is accessible

7. Immediately take a new FULL Online Exchange backup to protect the new database.

NOTE: if for some reason you don't want to do all of this manually check y profile for a product that can do all of the above for you and more.

Author Closing Comment

ID: 35070668
LVL 17

Expert Comment

ID: 35070726
Happy to assist, and if you ever need to contact me check my profile

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are times when we need to generate a report on the inbox rules, where users have set up forwarding externally in their mailbox. In this article, I will be sharing a script I wrote to generate the report in CSV format.
Want to know how to use Exchange Server Eseutil command? Go through this article as it gives you the know-how.
To show how to generate a certificate request in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.:  First we need to log into the Exchange Admin Center. Navigate to the Servers >> Certificates…
This video demonstrates how to sync Microsoft Exchange Public Folders with smartphones using CodeTwo Exchange Sync and Exchange ActiveSync. To learn more about CodeTwo Exchange Sync and download the free trial, go to:…

722 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question