+ Post New Thread
Results 1 to 13 of 13
Windows Thread, Shrinking Exchange 2003 Database in Technical; So has anyone ever managed to do this? We have treid all sorts of things but the datbase remains at ...
  1. #1
    Marvintpa's Avatar
    Join Date
    Jan 2007
    Location
    Grantham, Lincs
    Posts
    27
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Shrinking Exchange 2003 Database

    So has anyone ever managed to do this?

    We have treid all sorts of things but the datbase remains at 15Gb Minimum!

    We have almost all of the users data out using Exmerge. Defregmented the database offline using eseutils.

    But the database steadfastly refuses to shrink.....


    Any clues would be helpful.



    TIA

    Marvin

  2. #2

    Geoff's Avatar
    Join Date
    Jun 2005
    Location
    Fylde, Lancs, UK.
    Posts
    11,802
    Thank Post
    110
    Thanked 583 Times in 504 Posts
    Blog Entries
    1
    Rep Power
    224

    Re: Shrinking Exchange 2003 Database

    Did you do an online or offline defrag? Because an online defrag doesn't reduce the size of the database.. Have a read of this article:

    http://www.msexchange.org/tutorials/...G-ESEUTIL.html

  3. #3

    Join Date
    Jan 2007
    Location
    Enfield, London
    Posts
    159
    Thank Post
    7
    Thanked 3 Times in 3 Posts
    Rep Power
    17

    Re: Shrinking Exchange 2003 Database

    Quote Originally Posted by Marvintpa
    So has anyone ever managed to do this?

    We have treid all sorts of things but the datbase remains at 15Gb Minimum!


    Any clues would be helpful.

    TIA

    Marvin

    Journalling perhaps. If the journal mb is still active then because of single instance storage then the database will not shrink even if you appear to have 'cleared' the other accounts.

  4. #4
    FreeWill's Avatar
    Join Date
    Jan 2007
    Location
    North East
    Posts
    118
    Thank Post
    19
    Thanked 9 Times in 9 Posts
    Rep Power
    17

    Re: Shrinking Exchange 2003 Database

    Thanks for the suggestions.

    We tried an offline defrag using eseutil; after dismounting the public and private folders.

    m2d2 - where is the Journal Mailbox located? It doesn't appear that we have one - it is not located under the 'Mailboxes' folder in ESM.

  5. #5

    Join Date
    Aug 2005
    Location
    London
    Posts
    3,154
    Thank Post
    114
    Thanked 527 Times in 450 Posts
    Blog Entries
    2
    Rep Power
    123

    Re: Shrinking Exchange 2003 Database

    Why do you want to shrink the database?

  6. #6
    zag
    zag is offline
    zag's Avatar
    Join Date
    Mar 2007
    Posts
    3,736
    Thank Post
    893
    Thanked 414 Times in 348 Posts
    Blog Entries
    12
    Rep Power
    85

    Re: Shrinking Exchange 2003 Database

    If your problem is the 15gb limit of exchange standard SP1 there is a registry fix to enable larger sizes.

    Or just install Exchange 2003 SP2 so you can go up to 75gb no problem.

    If you have simply run out of space on your server then you got problems

  7. #7

    Join Date
    Jan 2007
    Location
    Enfield, London
    Posts
    159
    Thank Post
    7
    Thanked 3 Times in 3 Posts
    Rep Power
    17

    Re: Shrinking Exchange 2003 Database

    Quote Originally Posted by FreeWill
    m2d2 - where is the Journal Mailbox located? It doesn't appear that we have one - it is not located under the 'Mailboxes' folder in ESM.
    You may not have it setup as it would stand out if it were there.

    How about public folders? How big are pub.edb and pub.stm?

  8. #8
    FreeWill's Avatar
    Join Date
    Jan 2007
    Location
    North East
    Posts
    118
    Thank Post
    19
    Thanked 9 Times in 9 Posts
    Rep Power
    17

    Re: Shrinking Exchange 2003 Database

    We wanted to shrink the database because after clearing out all student mailboxes there was no way the database should have been 14GB.

    Since yesterday we (well - Marvintpa) have found the correct flag to use with eseutil which re-created the database minus the rubbish.

    For reference we used eseutil /d [mailtstore path] /p /t [drive&new database filename].

    We removed the old database and replaced it with the smaller one.

    The database is now 1.5GB, fully working without the rubbish

  9. #9
    Marvintpa's Avatar
    Join Date
    Jan 2007
    Location
    Grantham, Lincs
    Posts
    27
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    Re: Shrinking Exchange 2003 Database

    Quote Originally Posted by srochford
    Why do you want to shrink the database?
    We dont want to shrink it ... we needed to shrink it

    The server that holds our Exchange mail service has a limited disk capacity .. and we are once again without funds to upgrade it.

    After the departure of the students I decided to be a :twisted: facist :twisted: and delete all the mailboxes from the then) 10Gb Mailstore.
    Once I had done that and replaced the mailboxes for the essential staff (me, Freewill and a couple of lesser beings ) the mailstore had filled the partitiion.

    Anyway
    All is now fixed ..... the Mailstore is now back with all our (mine and Freewill) all Lesser Beings (Teachers and support staff) and no students
    and is only 5Gb.

  10. #10

    m25man's Avatar
    Join Date
    Oct 2005
    Location
    Romford, Essex
    Posts
    1,617
    Thank Post
    49
    Thanked 448 Times in 331 Posts
    Rep Power
    136

    Re: Shrinking Exchange 2003 Database

    As long as the disk holding the databases has at least as much free space as the live database the built in maintenance will keep things in check.
    Deleted mail and mailboxes will be retained until the retention policy is enforced and the old stuff is purged.

    Once free drive space has fallen to less than the database size you are in trouble, maintenance such as compressing and deleting whitespace can no longer take place and very quickly the database grows to it's maximum size and stays there until the store dismounts.

    If your database was 15Gb then you would need at least 15Gb of freespace.
    Deleted mail or mailboxes will not free up space until the retention period passes.
    A full online backup is needed to purge the logs.
    Remember SP2 does not increase the database size by itself, you still need to make a registry change.
    Increasing your database size will also increase your backup window requirement, a 75 GB Exchange store will need 75GB of free space and a backup window of about 2 days (hardly efficient).

    My best Exchange Tips are,
    Use the Enterprise version, have several storage groups that can be stored on different drives, back up each one individually.

    If you run out of disk space on your log drive and your store dismounts try using the built in NTFS File compression tool to squish the log files then do an online backup to purge them.

    If you plan on upgrading from standard to enterprise make sure you apply SP1 then SP2 and all hotfixes as you can break your IIS and OWA very easily.

  11. #11
    Grommit's Avatar
    Join Date
    Sep 2006
    Location
    Weston-super-Mare
    Posts
    1,335
    Thank Post
    31
    Thanked 54 Times in 31 Posts
    Rep Power
    24

    Re: Shrinking Exchange 2003 Database

    Quote Originally Posted by m25man
    As long as the disk holding the databases has at least

    If you run out of disk space on your log drive and your store dismounts try using the built in NTFS File compression tool to squish the log files then do an online backup to purge them.
    Can you not just delete the log files ?

  12. #12

    Join Date
    Aug 2005
    Location
    London
    Posts
    3,154
    Thank Post
    114
    Thanked 527 Times in 450 Posts
    Blog Entries
    2
    Rep Power
    123

    Re: Shrinking Exchange 2003 Database

    Quote Originally Posted by Marvintpa
    Quote Originally Posted by srochford
    Why do you want to shrink the database?
    We dont want to shrink it ... we needed to shrink it

    The server that holds our Exchange mail service has a limited disk capacity .. and we are once again without funds to upgrade it.

    After the departure of the students I decided to be a :twisted: facist :twisted: and delete all the mailboxes from the then) 10Gb Mailstore.
    Once I had done that and replaced the mailboxes for the essential staff (me, Freewill and a couple of lesser beings ) the mailstore had filled the partitiion.

    Anyway
    All is now fixed ..... the Mailstore is now back with all our (mine and Freewill) all Lesser Beings (Teachers and support staff) and no students
    and is only 5Gb.
    that makes sense! You don't gain anything in terms of more space in the mailbox store by shrinking it (ie a 15Gb file can have 15Gb of free space for mail but it does take up disc space)

    Is there anything else on the server which could move? Something which doesn't need fast disc and could go somewhere else (external USB drives are cheap)

  13. #13

    Join Date
    Aug 2005
    Location
    London
    Posts
    3,154
    Thank Post
    114
    Thanked 527 Times in 450 Posts
    Blog Entries
    2
    Rep Power
    123

    Re: Shrinking Exchange 2003 Database

    Quote Originally Posted by Grommit
    Quote Originally Posted by m25man
    As long as the disk holding the databases has at least

    If you run out of disk space on your log drive and your store dismounts try using the built in NTFS File compression tool to squish the log files then do an online backup to purge them.
    Can you not just delete the log files ?
    You really don't want to do that - if ever you need to restore, you won't be able to do it without the log files. They will be deleted automatically when a backup completes successfully; log files dated older than your last backup tell you that your last backup failed (eg we backup the exchange stores at 2200 each night; any .log file older than that is a quick indication that something went wrong with the backup)

SHARE:
+ Post New Thread

Similar Threads

  1. Outlook 2003 and Exchange Server 2003
    By faza in forum How do you do....it?
    Replies: 9
    Last Post: 8th October 2009, 08:16 PM
  2. Printing Shrinking
    By markwilliamson2001 in forum Windows
    Replies: 2
    Last Post: 5th November 2007, 11:43 AM
  3. Replies: 6
    Last Post: 20th November 2006, 11:49 PM
  4. Replies: 4
    Last Post: 27th May 2006, 02:48 PM
  5. Exchange 2003 and Server 2003 SP1 issue.
    By tosca925 in forum Windows
    Replies: 0
    Last Post: 21st August 2005, 10:32 PM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •