?
Solved

Exchange 2003 Keeps Going Offline

Posted on 2012-03-23
14
Medium Priority
?
662 Views
Last Modified: 2012-04-02
Recently our Exchange database reached its limit and went offline. I brought it back online and we archived the emails to reduce the size. But the database still goes offline and in the event log it show that the database is over the 18gb limit. The database is now 10gb.

How do I resolve this issue?
0
Comment
Question by:mail2clk
[X]
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
  • 6
  • 3
  • 2
  • +2
14 Comments
 
LVL 76

Expert Comment

by:Alan Hardisty
ID: 37756401
If you increase the maximum database size in the registry, you can prevent this from happening until the database gets too big again (details in the link below):

http://support.microsoft.com/kb/912375

Set something like 40Gb to give yourself some time to play and some room to grow.

Once you hit 75Gb - you can't get any bigger and would either need to archive or upgrade.
0
 

Author Comment

by:mail2clk
ID: 37756409
We are already down to 10gB. I am concerned there is a corruption somewhere. Offline defragmentation took nearly 6.5hrs.
0
 
LVL 76

Expert Comment

by:Alan Hardisty
ID: 37756435
The store will retain deleted items for the duration of the setting on the database for deleted item retention.

If you edit the registry to allow the database to be actually larger than the default 18Gb limit, then your problem will go away.
0
Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

 
LVL 4

Expert Comment

by:mattyb_
ID: 37756441
There shouldn't be any corruption with the actual database due to the fact that when you complete an offline degrag, there is a new database created and the old one removed.
Any corruption could stop that process.

6.5 hours does not seem an overly long time for a defrag as this will normally take an hour for every 5 -7 gb of data.

The database reporting is the combination of both the edb file + the stm file - any free space.

Exchange Database size calculation

Have a look through your event logs for an 1221 event. You should have one of those for each database (private and public). This will show you how much free space is available.

If your STM database is quite large, that may show that you are being used as an open relay, so check that out.

Personally, if not done already patch your exchange to SP2, you can then increase your database size limit upto 75Gb.

Exchange 75Gb database limit
0
 
LVL 11

Expert Comment

by:TheGeezer2010
ID: 37756592
Are you running Full or Incremental Backups regularly to truncate the Transaction Logs - if not you are going to experience big problems recovering.
0
 
LVL 76

Expert Comment

by:Alan Hardisty
ID: 37756597
How is that relevant to the issue being discussed?
0
 

Author Comment

by:mail2clk
ID: 37756627
I've applied the fix and increased the database size. Would enabling " Zero out deleted pages" help with the issue?
0
 
LVL 11

Expert Comment

by:TheGeezer2010
ID: 37756628
>>I brought it back online and we archived the emails to reduce the size<<
0
 
LVL 76

Accepted Solution

by:
Alan Hardisty earned 2000 total points
ID: 37756635
If you have increased the database size - that should be all you need to do to stop the store dismounting.  You should now have time and space to grow into the database some more before having further problems and I would leave it at that.
0
 
LVL 76

Expert Comment

by:Alan Hardisty
ID: 37756642
TheGeezer2010 - And?
0
 

Author Comment

by:mail2clk
ID: 37756652
Attached is a screenshot of the file size.
Screen-shot-2012-03-23-at-11.52..png
0
 
LVL 17

Expert Comment

by:Suraj
ID: 37756655
Ask users to make pst and move large emails to them.
Run online maintenance.
then dismount and then run offline defrag. This will help you for sure.
http://support.microsoft.com/kb/324358
http://support.microsoft.com/kb/328804
0
 
LVL 76

Expert Comment

by:Alan Hardisty
ID: 37756668
You don't need to perform an offline defrag - what good is that going to do?  The database size has been increased and the problem will now be resolved.

Event ID 1221 will advise how much space an offline defrag will be able to reclaim and if you want to take the store offline to perform a slow defrag and have users unable to access their emails whilst the defrag takes place, then fair enough - but it will be offline for about 4-5 hours, which is utterly pointless.  After 30 days (default), the space will be reclaimed in the database from the messages that have been archived.

If disk space is an issue and you need to shrink the database, then perform an offline defrag, but it currently a waste of time.
0

Featured Post

Industry Leaders: 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!

Question has a verified solution.

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

Lotus Notes – formerly IBM Notes – is an email client application, while IBM Domino (earlier Lotus Domino) is an email server. The client possesses a set of features that are even more advanced as compared to that of Outlook. Likewise, IBM Domino is…
This article will help to fix the below errors for MS Exchange Server 2013 I. Certificate error "name on the security certificate is invalid or does not match the name of the site" II. Out of Office not working III. Make Internal URLs and Externa…
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: http://www.codetwo.com/excha…
Suggested Courses
Course of the Month7 days, 19 hours left to enroll

765 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