My priv1.edb and priv1.stm are increasing in size by the day-What shud I do ?

Hi Guys,

My Priv1.edg and Priv1.stm are increasing day by day. What are the steps I should take to decrease or control their size? please help ?
Amir4uAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
Is there any abnormal growth.
If not the only way is to Offline Defrag.
0
hau_itCommented:
Defrag the databases and set smaller limits for the mailboxes
0
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
You would have to Offline Defrag the database and this would require Downtime of the store as they would be dismounted till the time this operation runs.
0
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
Also to inform you that apart from Offline defrag we have to isinteg the database after Offline defrag as the pages in the database would be re-organised and there are chances of some logical corruption, so to remove the logical corruption we have to run Isinteg command.
0
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
Would like to know what is the size of the database (.edb and .stm) and how much free space we have on the drives on the server ?
0
Rajith EnchiparambilOffice 365 & Exchange ArchitectCommented:
What are your DB size like and what is the growth rate?
0
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
Hello Amir are you there ?
0
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
Any update on the issue ?
0
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
Any update on the issue ?
0
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
Is the issue still pending or resolved ?
0
Amir4uAuthor Commented:
thanx guys for the responses.

priv1.edb = 49.389 GB

priv1.stm = 31.393 GB

0
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
If this is Standard Exchange its a problem .... As the Permisible is 75 Gb MAX and your DB size is 80 Gb already.
The olny thing is to run Offline Defrag, but we still want to know about the free space in the DB.
0
Amir4uAuthor Commented:
how can we know how much free space is left inside the DB?
0
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
You would have to dismount the stores and run the command
eseutil /ms "location of the .edb file" this would run depending on the size of the DB and in the last would give you the number of free pages. Now multiply th enumber of pages by 4 and that would give you the free space in DB in KB's (kilobytes).
0
Amir4uAuthor Commented:
Thanx rancy ..also ...after dismounting the store shall I copy these databases somewhere else and let the original one mount again? then i simply run the offline defrag on it and then wen it is done i just dismount the original one "move" it and then copy the new one there and mount it ?

about the free space u said u still want to know ...why ?
0
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
No ... because if we dismount and run Offline defrag on a copied database in the mean time the original database is getting new mails and out so if you defrag the copied and keep it back users would loose new data and that would be more mess and work.

the reason i want to know the free space is to see that if we have 80 Gb database and for example  we have only 500 Mb free space then there is no good reason to keep my DB down for that time and get just .5Gb free space !!

Also to inform you that the Offline Defrag runs at 4-5 Gb per hour and requires 100% free space on the drive where we have the bin folder or from the location we run the command.
0
Amir4uAuthor Commented:
mine is enterprise exchange 2003 SP2 on windows EE SP2
0
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
SO there is another Option of creating new stores and just moving mailboxes and dividing so that we can reduce the size of the stores. As in Enterpries edition of Exchange we have a total number of 20 Stores divided in 4 Storage Groups .....
0
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
As we have Enterprise edition of Exchange, the best would be to create more stores and just move users within the new stores. Once all users have been moved we can remove the DB files manually be dismouting the stores.

Let me know what you would like to go with ?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Amir4uAuthor Commented:
If I move half of the users to the other store? would this solve my prob ? also i need to increase the Disk space? adding new HDD to the current RAID 5 ?
0
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
What i would suggest is to add a HDD with good amount of free space.
Create may be like 4 New Stores. Move all the mailboxes to these stores dividing them equally so that all the stores have small size and is easy to maintain them.
Once all the mailboxes have been moved you can then dismount the Original store and remove the DB files manually.

Now few questions
1. What is the current size of the Store ?
2. How many mailboxes do we have ?
0
Amir4uAuthor Commented:
We have 1800 Mailboxes

Store size:
priv1.edb = 49.389 GB

priv1.stm = 31.393 GB
0
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
Humm ... So why dont we divide them equally by creating about 10 mailbox Stores in 2 New Storage Groups. Like about 150-200 users in one Store that would mean that the Store size would be small as well.
0
Amir4uAuthor Commented:
will this small store size be of any benefit in the fast delivery and recieving of emails? or is it just related to the storage?
0
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
Its good for example the mail routing is quick as user have different stores and each store has a store driver.
Also if there is a problem with the DB, all the user wont be affected, just some users and the Backup and restore for one store would be quicker. Also administration would be easier. As you can create stores with Designation or department or role anything you like.
0
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
Any updates or we can close and award the points .....
0
Amir4uAuthor Commented:
Hi Rancy today i will perform this kindly stay with me .....thanx
0
Manpreet SIngh KhatraSolutions Architect, Project LeadCommented:
Hello Amir, Any updates ?
0
Amir4uAuthor Commented:
I was not able to perform this that day ....too much work from other side pouring on me ....but i will try now ...thanx so much for follow-up rancy ...
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Exchange

From novice to tech pro — start learning today.