Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Huge pub1.edb file... not sure why!

Posted on 2006-04-19
9
Medium Priority
?
1,548 Views
Last Modified: 2012-06-22
Hi all... running SBS 2003 Standard. Our Priv1.edb size is around 6GB, the Pub1.edb however is a massive 90gb!! I have looked at the "Public Folders" branch in the ESM and the largest file there is 7MB. Am at a loss as to whats causing this for now. The only thing I can guess at that is causing this is the "Archive Messages" setting on the Mailbox Store "General" Properties Tab. Initially I had this enabled and pointing to an "<domain> Archive"  Public Folder that was already setup but contained within the "Microsoft Exchange System Objects" container. After setting this up I forgot about it but then got a nasty shock when the Public Store dismounted. Backups have been running fine, so logs are flushed and maintenance has been performed on the databases etc..

I tried to access the contents of the "<domain> Archive"  Public Folder but could not. Have since created a new Public Folder and changed archive setting to point to it. My main concern is now to try and get this Pub1.edb size right down.

Any help would be gratefully appreciated!!

Nellster
0
Comment
Question by:nellster
  • 4
  • 3
7 Comments
 
LVL 35

Expert Comment

by:rakeshmiglani
ID: 16485818
if you were archiving messages to a public folder then, i guess that the size of that public folder would be contributing towards the total size of you pub1.edb file

is message archiving still enabled?


check the deletion settings on the public folder store.

offline defrag can be run the reduce the size of the public folder database, but it would require 110% of free disk space of the public database size.

have you checked the application logs for online maintenance eventsfor the public store? what does it tell you about free space in that event.
0
 

Author Comment

by:nellster
ID: 16486804
Thanks for the reply rakeshmiglani. Have checked the events log for last night and over the course of the night I had a few logs like the one below;

"Description:
The database "First Storage Group\Public Folder Store (COMPUTER)" has 92405 megabytes of free space after online defragmentation has terminated. "

Does this mean that the space should have been free after the defragmentation? Or is it only an offline defrag that will do that?

Deletion settings on public folders are basically non existant. Apart form the Archive Folder there are no mailbox items as Public Folders.

Thought, if I were to adjust the rentention limits and try and delete the initial system "Archive" folder, that should free up some space correct? Wise to delete an object in the Exchange System Object's container?

Regards,

Nellster
0
 
LVL 35

Accepted Solution

by:
rakeshmiglani earned 1000 total points
ID: 16486882
92405 MB comes to approx 90 GB

this is all white space and will be re-claimed with an offline defrag.

if that Archive folder is no longer required then you can delete it. I would not recommend deleting it from the MESO container. you can delete it from the ESM as well.

before you delete that "archive" folder you need to disable the message archiving or designate another folder/mailbox for mail achiving

How to defragment with the Eseutil utility (Eseutil.exe)
http://support.microsoft.com/kb/192185/en-us

Support WebCast: Microsoft Exchange: Offline Defragmentation with the Eseutil Utility
http://support.microsoft.com/kb/324672/en-us

How to run Eseutil on a computer without Exchange Server
http://support.microsoft.com/kb/244525/en-us
0
NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

 

Author Comment

by:nellster
ID: 16487473
thought that might be the case. Thanks for the reply. Offline defrag on that lot will take an age.. goodie!

Would like to delete the initial Archive public folder but it does not appear in the Public Folder list in the ESM. Only in AD.

0
 
LVL 35

Expert Comment

by:rakeshmiglani
ID: 16487521
Was that folder deleted at some point of time?

in esm, you can check this at two places.

1) expand public folder tree at the bottom of esm and look at the folder
2) expand public folder tree and check the public folder

if the public folder is not listed in esm anywhere then you don't need to worry about it

what is the status of the message archive settings? is that still enabled?
0
 

Author Comment

by:nellster
ID: 16487910
The origional "Archive" settings for the mailbox store was set to a public folder named "Company Archive". This folder does not show in the ESM Public Folder tree, neither in the Folders tree at the bottom. The only place I could find it was within Active Directory/Microsoft Exchange System Objects where it's type was "Public Folder". If its not listed in the ESM and I don't need to worry about it I am concerned as to how the Pub1.edb became so big, seeing as the accumilated size of all the folders displayed in the Public Folder tree of the ESM is approx 10mb. Very strange.

I have created another Public Folder to Archive to which I can access fine. I have disabled archiving for now.

Cheers,

Nellster
0
 
LVL 35

Expert Comment

by:rakeshmiglani
ID: 16487947
good, then you are all set. you just need to run the offline defrag on pub1.edb to reclaim the white space.

you can check the above listed kb articles also for online defrag
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

With so many activities to perform, Exchange administrators are always busy in organizations. If everything, including Exchange Servers, Outlook clients, and Office 365 accounts work without any issues, they can sit and relax. But unfortunately, it…
This article will help to fix the below errors for MS Exchange Server 2016 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…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Suggested Courses

810 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