[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 600
  • Last Modified:

reclaiming whitespace in exchange 2007 edb file

Right now i have a mail DB that is about 60 gb with 24 gb of whitspace.  i want to do an offline defrag but i am wondering what the best way to this would be.  my question is i have a partition that the edb file is on that is 107 gb total, i have read that you need at least 110 percent the size of the DB in free space to the offline defrag.  I did find this command which leads me to beleive you can use a temp location making the "110 percent free space" part unnecessary.  Does this sound correct

eseutil /d <database_path_and_file_name> /t <temp_database_path_and_file_name>

As it stands now i only have 44gb of free out of 107 gb space on the drive containing the 60gb mail DB.  If my math is correct that = not enough room to do the offline defrag.

Any advice is appreciated experts.  Thanks!
0
IKtech
Asked:
IKtech
  • 7
  • 5
  • 3
  • +1
3 Solutions
 
IKtechAuthor Commented:
BTW the temp drive would be a USB drive.  Hope that doesn't affect the situation at all.  Thanks again
0
 
Deepu ChowdaryCommented:
Its not recommended to perform eseutil on usb drives.
What you can do is copy the db to usb drive (backup) and then run
Eseutil /d dbpath(simply drag and drop .edb file on command window).

Comming to pre-requsists :
110 % free space is needed for sure.
Network location not preferable
Also if you have other machine which is having enough space to do this you can copy the db files and bin folder to that machine and can perform the same operation.
You cannot run isinteg on that machine, only eseutil is possible..
0
 
IKtechAuthor Commented:
So if i understand you correctly i can dismount the .edb file and copy it to the usb drive and then use
eseutil /d path to db to defrag it.  Is the database the only file i need to copy?

once this is complete i am assumming i  need to replace the .edb file on the server with the defraged database on the usb drive then mount it?

0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Deepu ChowdaryCommented:
Hmm if you are not having enough space on the server but want to do offline defrage then

1) Copy EDB, STM files & Bin folder in exchange installation path to a USB drive.
2) Copypaste all those to the machine having free space and run defrage. (keep a copy in usb drive, dont cut paste use copy paste)
3) Copy back the defragged db to the original location.
4) Mount and dismount the DB and then run Isinteg.
0
 
Jamie McKillopCommented:
Hello,

Do not run eseutil. It is completely unnecessary, will cause considerable downtime, and carries a risk of damaging your database. Why do you want to reclaim the whitespace? It will eventually fill back up again. If you really want to reclaim the space, the best way to go about it is to create a new mail store and move all your mailboxes to this new store. Once all the mailboxes have been moved, you can delete the original store. This will cause the least disruption to users and is much safer. This is assuming you haven't maxed out the number of allowable databases if you are running the standard version of Exchange.

JJ
0
 
IKtechAuthor Commented:
i found this:

1.Create a new folder on the computer that does not have Exchange Server 2007 installed.
2.Copy the Eseutil.exe, Ese.dll, Jcb.dll, and Exchmem.dll files from the Exchange Server 2007 computer's Drive:\Program Files\Microsoft\Exchange Server\Bin folder to the new folder that you created.
3.At a command prompt, change the directory to the new folder.
4.Run the eseutil command from this folder against any databases that were copied from the Exchange Server 2007 computer.

This sounds easy enough.  Once i have defragged and copied the DB back to the exchange server, why do i need to mount then unmount and run isinteg.  If this step is necessary, can you include more details or the syntax of this command?  Finally what do you mean by stm files?
0
 
IKtechAuthor Commented:
@JJ
i don't think i have enough room to create the new mail store either.  With 44 GB of free space on the D: (which is where my databases are located, i only have two) and about 18 gb of free space on the E drive where the transaction logs are.  I am under the impression that the migration of the mail box from one store to another creates large transaction log files.  Could you provide some more details as to how this is done and what to expect?  Thanks!
0
 
Deepu ChowdaryCommented:
Copy edb and stm files along with BIN folder to another machine which is having enough disk space and perform offline defrag in that machine.
0
 
kieran_bCommented:
So, you have a 107gb drive, with a 60gb mailstore, with only 36gb of data in it and roughly 40gb of free space on that partition?

I would also recommend against doing an offline defrag, it is slow and pointless.

I actually don't think you have a problem at all, I mean, that whitespace isn't causing you harm.

If you must do it, I would enable circular logging so you don't drown in transaction logs, and move everything to a new database - it is the recommended solution ahead of a defrag.

Kieran
0
 
Jamie McKillopCommented:
You have 36GB of data and 44GB of free disk space, so you have enough free space. Moving 36GB of mailboxes will create 36GB of transaction logs, so you don't have enough free space on your TLog drive do do this all at once. What I recommend you do is break it up int three or four groups. Assuming you do a backup every night, you would do a group on day 1, the backup that night would clear the logs, do the next group on day 2, the back that night would clear the logs, etc.

JJ
0
 
IKtechAuthor Commented:
@jjmck
i've only got 31 mailboxes.  How long do you think that would take to move to a new database?

Aside from the fact that i can't do them all at once due to size of transaction logs partition
0
 
Jamie McKillopCommented:
That is hard to answer as it depends on a lot of variables like the mailbox size, the number of items in the mailbox and the performance of your server and disk system.

JJ
0
 
kieran_bCommented:
The answer isn't to break it up, the answer is to use circular logging of transaction logs - the more you spread out a move, the more likely it is going to go horribly wrong.
0
 
Jamie McKillopCommented:
I disagrees-[
0
 
Jamie McKillopCommented:
I disagree. I would never enable circular logging on a production server. How does spreading out over multiple night make it more likely something will go wrong? It is more likely something will go horribly wrong if you enable circular logging. If you have some type of issue while doing the move and have to restore you will lose data with circular logging enabled.
0
 
kieran_bCommented:
You will potentially lose an hours worth of data, yes.  But it is a faster and cleaner process.

To each their own, I am giving my professional opinion.
0
 
IKtechAuthor Commented:
i ended up not doing the defrag.  I got around it by adding more disk space.  Thanks for the help!!!
0
 
IKtechAuthor Commented:
Thanks again!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 7
  • 5
  • 3
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now