Solved

Exchnage 2007 SP2 Need help shrinking Database

Posted on 2010-08-15
15
997 Views
Last Modified: 2012-05-10
I tried to use this command and I get a Syntax error
The command I am using is
C:\Program Files\Microsoft\Exchange Server\Bin>eseutil /d c:\program files\excha
nge server\mailbox\First Storage Group\Mailbox Database.edb . This is the default that I used to install.

There error I get when I try to run which I dismounted both Database .
C:\Program Files\Microsoft\Exchange Server\Bin>eseutil /d c:\program files\
nge server\mailbox\First Storage Group\Mailbox Database.edb

Usage Error: Invalid argument 'files\exchange'. Options must be preceded by
or '/'.

Extensible Storage Engine Utilities for Microsoft(R) Exchange Server
Version 08.02
Copyright (C) Microsoft Corporation. All Rights Reserved.

DESCRIPTION:  Database utilities for the Extensible Storage Engine for Micr
(R) Exchange Server.

MODES OF OPERATION:
      Defragmentation:  ESEUTIL /d <database name> [options]
             Recovery:  ESEUTIL /r <logfile base name> [options]
            Integrity:  ESEUTIL /g <database name> [options]
             Checksum:  ESEUTIL /k <file name> [options]
               Repair:  ESEUTIL /p <database name> [options]
            File Dump:  ESEUTIL /m[mode-modifier] <filename>
            Copy File:  ESEUTIL /y <source file> [options]
              Restore:  ESEUTIL /c[mode-modifier] <path name> [options]

<<<<<  Press a key for more help  >>>>>
D=Defragmentation, R=Recovery, G=inteGrity, K=checKsum,
P=rePair, M=file duMp, Y=copY file, C=restore
=>
0
Comment
Question by:Jryals8900
  • 7
  • 6
  • 2
15 Comments
 
LVL 74

Expert Comment

by:Glen Knight
ID: 33441624
Doing an offline defray with Exchange 2007 is a waste of time.

Just create a new store and move the mailboxes to it.

No downtime, a completely defrauded and error free store and no chance of data loss.

Read my article here: http://www.experts-exchange.com/Software/Server_Software/Email_Servers/Exchange/A_2730-Exchange-Offline-Defrag.html
0
 

Author Comment

by:Jryals8900
ID: 33441640
I am really trying to free Upspace. The DB says My Storage group is 21 gigs. Maybe I aksed the question wrong. I want to reduce the Size of this.
0
 
LVL 74

Expert Comment

by:Glen Knight
ID: 33441654
If there is no whitespace in the database there is nothing you can do to reduce space.  You will need to delete/archive email from mailboxes.  This will create whitespace.

Then if you have whitespace simply create a new mailbox store and move the mailboxes to this store then delete the old one.

With exchange 2007/2010 there is no need to run an offline defrag.  Have a read of my article.
0
 

Author Comment

by:Jryals8900
ID: 33441752

What is whitespace .. SOrry ?

Thanks. I feel my users are just not deleting. I did read your article event id is 689 megs. Any way to Archice Email from the server side vs users exporting to Archive folders. We are planning to install Exchange 2010 after I decommsssion a good ol 2000 DC LOl
ANy articles you send my way of havving Policies on 14 days your Trash will be deleted?
0
 
LVL 74

Expert Comment

by:Glen Knight
ID: 33441783
Whitespace is "free" space in the database.

Funny you should mention articles, you might want to checkout another of mine here: http://www.experts-exchange.com/Software/Server_Software/Email_Servers/Exchange/A_3538-Deleting-mail-of-a-certain-age-from-Exchange-mailboxes.html

Don't forget if you find my articles useful please vote for them :)
0
 
LVL 14

Expert Comment

by:Shabarinath Ramadasan
ID: 33441787
If the white space is only 689 MB, you are not gaining anything by an offline defr.
Also, if you make all the users archive, still the DB size wont come down if you are not doing an offline defrag. So better approach is to add one more DB in the Drive where you have space and create a new DB there. Move users to the new DB and delete the old DB.

Good Luck !
Shaba
0
 
LVL 14

Expert Comment

by:Shabarinath Ramadasan
ID: 33441804
And why you are getting the error while trying eseutil?

its just because the path for exchange DB  should be with in quotes.

eseutil /d "c:\program files\exchange server\mailbox\First Storage Group\Mailbox Database.edb"

FYI - You should have 110% free space for trying an offline defragmentation.

Cheers !
-Shaba-
0
Free book by J.Peter Bruzzese, Microsoft MVP

Are you using Office 365? Trying to set up email signatures but you’re struggling with transport rules and connectors? Let renowned Microsoft MVP J.Peter Bruzzese show you how in this exclusive e-book on Office 365 email signatures. Better yet, it’s free!

 

Author Comment

by:Jryals8900
ID: 33441853
When I run the utility
it gives me this and both databases are dismounted

C:\Program Files\Microsoft\Exchange Server\Bin>eseutil /d "c:\program files\exch
ange server\mailbox\First Storage Group\Mailbox Database.edb"

Extensible Storage Engine Utilities for Microsoft(R) Exchange Server
Version 08.02
Copyright (C) Microsoft Corporation. All Rights Reserved.

Error: Access to source database 'c:\program files\exchange server\mailbox\First
 Storage Group\Mailbox Database.edb' failed with Jet error -1811.

Operation terminated with error -1811 (JET_errFileNotFound, File not found) afte
r 0.0 seconds.
0
 

Author Comment

by:Jryals8900
ID: 33441865
oopes... I has the PAth wrong !!!! Sorry I will run anway to see hwat happens
0
 
LVL 74

Expert Comment

by:Glen Knight
ID: 33441884
There is no need to run it! It's a complete waste if time and potential for data loss!
Have you ready article???
0
 

Author Comment

by:Jryals8900
ID: 33442359
Ok.. I strarted the Defrag ... Now I have 50 megs of Free space. Where are the Temp files stored during this process?
Its a Virtual Server so I guess I can create another drive or send to a network share? Where do I tell the app on where it sends to? Before I started I had 9 gigs free? HELP
0
 

Author Comment

by:Jryals8900
ID: 33442369
Or how do I undo this defrag?
Is there a switch that puts the Database to get it back to 9 gigs free on the drive? Then I am rebuilding another virtual server to Exchange 2010 .. Just trying to buys ome time :-)
0
 
LVL 74

Expert Comment

by:Glen Knight
ID: 33443285
Why did you run a defrag?
Did you not read my article or posts?

It's a complete waste of time on anything other than standard edition if exchange 2003.

Exactly the same results can be achieved by creating another data store and moving the mailboxes.

I am not going to participate in this question any further.
0
 

Accepted Solution

by:
Jryals8900 earned 0 total points
ID: 33667106
Called Microsoft and had them work with me on fixing this. Thank you all for your help.
0
 
LVL 74

Expert Comment

by:Glen Knight
ID: 33667165
Would you mind explaining what you did and why?
The information I provided was correct.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Not sure what the best email signature size is? Are you worried about email signature image size? Follow this best practice guide.
Following basic email etiquette rules will help you write a professional email and achieve a good, lasting impression with your contacts.
In this video we show how to create an email address policy 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 Mail Flow…
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…

757 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

23 Experts available now in Live!

Get 1:1 Help Now