Solved

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

Posted on 2011-02-25
7
219 Views
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.

0
Comment
Question by:maxalarie
  • 2
  • 2
  • 2
  • +1
7 Comments
 
LVL 27

Expert Comment

by:davorin
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.
0
 
LVL 8

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.
0
 
LVL 2

Author Comment

by:maxalarie
ID: 34982938
Ok, Thanks you. I do not have that much space left on the server at the moment.
Thanks for the help.
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
LVL 27

Assisted Solution

by:davorin
davorin earned 250 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:
http://msexchangeteam.com/archive/2004/07/08/177574.aspx
http://exchangeshell.wordpress.com/2009/11/03/exchange-2007-physical-edb-database-size-too-large-reduce-size-move-mailbox-offline-defrag/
0
 
LVL 17

Accepted Solution

by:
lucid8 earned 250 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 http://technet.microsoft.com/en-ca/library/aa996139(EXCHG.65).aspx 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 http://support.microsoft.com/kb/192185 and this is a good read as well http://technet.microsoft.com/en-us/library/aa997972(EXCHG.80).aspx  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 http://support.microsoft.com/kb/301460  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.
0
 
LVL 2

Author Closing Comment

by:maxalarie
ID: 35070668
Thanks.
0
 
LVL 17

Expert Comment

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

Featured Post

Are end users causing IT problems again?

You’ve taken the time to design and update all your end user’s email signatures, only to find out they’re messing up the HTML, changing the font and ruining the imagery. What can you do to prevent this? Find out how you can save your signatures from end users today.

Join & Write a Comment

Suggested Solutions

Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
Marketers need statistics and metrics like everybody else needs oxygen. In this article we explain how to enable marketing campaign statistics for Microsoft Exchange mail.
In this video we show how to create a mailbox database 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 >> Data…
The video tutorial explains the basics of the Exchange server Database Availability groups. The components of this video include: 1. Automatic Failover 2. Failover Clustering 3. Active Manager

760 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

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now