Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

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

problem with database on exchange

i have exchange 2003 and in database folder i see the size 76GB edb38GB and stm40gb but if i export list of all mailbox size the total size is 38GB so what is the problem?and what i need to do?
0
buildingit
Asked:
buildingit
  • 12
  • 8
1 Solution
 
Glen KnightCommented:
The physical size if the database and the size reported by the suE of the mailboxes is not representitive because ESM only shows you the contents if 1 database.

Look for event 1221 in the event viewer how much Whitespace does it say you have?

If physical storage is a prolem and there is a large amount of whitespace reported then you could perform an offline defrag of the database using ESEUTIL to reduce the physical size but this is only worth doing if you have a large amount of whitespace if you don't it's a waste if time, see here for how: http://www.msexchange.org/tutorials/Exchange-ISINTEG-ESEUTIL.html
0
 
buildingitAuthor Commented:
i did offline defrag but still have the same size of database but i now that is imposible that i have 70GB now chance so it is maybee problem what else i can do or check
0
 
Glen KnightCommented:
What does the event ID 1221 report?

What do you have your deleted items retention period set to?
if the whitespace doesn't exist there is no point in doing an offline defrag.

You can create whitespace quickly by setting the deleted items retention period to 0 then setting the maintenance schedule to every 15 minutes and then restart the System Attendent service.

Once whitespace is created you can do an offline defrag to reduce the size.
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
Glen KnightCommented:
See the mailbox management section of this link for setting the deleted items retention period: http://www.msexchange.org/tutorials/Mailbox-Management.html
0
 
buildingitAuthor Commented:
the evete 1221 say"The database "First Storage Group\Public Folder Store (EXCHANGE)" has 5 megabytes of free space after online defragmentation has terminated.
0
 
Glen KnightCommented:
Then there is only 5 MB if whitespace.

You can create more by setting the retention periods as I mentioned earlier.

What are the retention periods currently sry to?

Once you have set the retention periods get users to archive/delete any un-needed emails and then schedule the maintenance to run every 15 minutes then check for 1221 again after sn hour.
0
 
Glen KnightCommented:
Sorry that was for the public folder store, is there another event around the same time for the private store?
0
 
buildingitAuthor Commented:
no
0
 
Glen KnightCommented:
Check the database and ensure that the maintenance is scheduled to run as per: http://support.microsoft.com/kb/328804
0
 
buildingitAuthor Commented:
in my interval i see that is running between 01:00am to 05:00 am
0
 
Glen KnightCommented:
And what are the deleted items set to?
0
 
MesthaCommented:
The list of mailboxes will never equal the size of the store. There are various reasons for this - the main one being that ESM only lists the content in one of the two database files.

I have explained more about what is going on here:
http://blog.sembee.co.uk/archive/2009/07/21/105.aspx

An offline defrag was a waste of time because the limit is soft enforced and already takes in to account the white space.

Simon.
0
 
buildingitAuthor Commented:
i heard that have third party software to do offline defrag to exchange what is the best?
0
 
Glen KnightCommented:
Why se a 3rd Party tool ESEUTIL will do the job.
0
 
Glen KnightCommented:
Any defrag will only remove whitespace as per my first post.

If you don't have any whitespace then there is little point.

I would only recommend an offline defrag is PHYSICAL space is an issue? If not leave well alone.
0
 
buildingitAuthor Commented:
ok now later on you answer me i set the retention periods  to 0 and after the night i see in few event log with 1221 my interval maintance run from 01:00 -05:00 i see 2 time that free space 3mg and in 02:30 free space 7594mg what is mean?
0
 
Glen KnightCommented:
One will be refering to the public folder store which is the 3mg the other will be the mailbox store which now has 8GB of free space.
0
 
buildingitAuthor Commented:
ok now i need do do offline defrag ?
0
 
Glen KnightCommented:
Is 8GB really worth it?
Are you having problems with physical space on the server?

What are the sizes of your priv1.edb and priv1.stm files?
0
 
buildingitAuthor Commented:
i told you the problem is that my edb38gb and stm37gb and they stiil that dont meter what i do,and i now that is imposible that i have size this/
0
 
Glen KnightCommented:
Take your database offline, make a copy of both the EDB and STM files for backup purposes and run the following command:

ESEUTIL /D "full_path_to_edb_file.edb"

It may well defrag the STM file but it's only going to reduce your EDB file by 8GB.

This could take around 10 hours on a database your size so expect to be offline for a while, don't remount the database until this process is complete.
0

Featured Post

Has Powershell sent you back into the Stone Age?

If managing Active Directory using Windows Powershell® is making you feel like you stepped back in time, you are not alone.  For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why.

  • 12
  • 8
Tackle projects and never again get stuck behind a technical roadblock.
Join Now