The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.
COURSE of the MONTH
10 days, 20 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Can you make an Exchange 2003 6.5 Priv1.edb Priv1.stm database smaller?
Posted on 2010-09-21
I have an exchange server thats database completed filled up the database partition. The database partition is 60GB and the database grew to 60GB. Last night I took the server offline ( well it took itself offiline) and did an ESEUTIL /D and it trimmed about 2GB from the database. Now I have about 2GB of breathing room on the data partition.
Is there anything else I can do to make the priv1.edb and priv1.stm smaller? Does deleting emails make the database smaller?
Please help!!!
Is there anything else I can do to make the priv1.edb and priv1.stm smaller? Does deleting emails make the database smaller?
Please help!!!
[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
2-
2
4 Comments
Active 2 days ago
Deleting emails can make the database smaller over time, but it depends on what settings you have on this server for retention of deleted items. That is something to look into, and if that retention time is very long (i.e., 20 days or more), you might be able to gain a little bit of breathing room by shortening it. You will still need to make sure that on-line defragmentation is running on a regular basis, though, because that space is not regained unless the database is defragged regularly. Normally, the on-line defrag process keeps up with deleted items very effectively.
Unless you severely trim your database, however, it's doubtful you're going to gain enough space on that drive to give you more than a short time before you'll be in the same situation. What you really need to do is move that database to a larger partition. If you don't have a larger partition on that server, then you need to add disk storage to that server so that you have a partition large enough to accommodate the database and anticipated growth. Unless you have the Enterprise edition of Exchange, the maximum database size is 75GB anyway and you can't add another mailbox store, so you may need to look at upgrading your Exchange version some time soon so that you can allow you database to growth beyond the 75GB limit.
Unless you severely trim your database, however, it's doubtful you're going to gain enough space on that drive to give you more than a short time before you'll be in the same situation. What you really need to do is move that database to a larger partition. If you don't have a larger partition on that server, then you need to add disk storage to that server so that you have a partition large enough to accommodate the database and anticipated growth. Unless you have the Enterprise edition of Exchange, the maximum database size is 75GB anyway and you can't add another mailbox store, so you may need to look at upgrading your Exchange version some time soon so that you can allow you database to growth beyond the 75GB limit.
I just changed the Deletion Settings to 1 days for items and 1 day for mailbox. Now if I delete a few old mailboxes, and have users achive all old emails will I see a big reduction in size of the database after 1 day? ( after the retention for deleted items runs).
We have an compliance mailbox where all sent items and received items go to. This mailbox is only access my the owners of the company and it has grown to 28GB. If I achive the whole thing down to a couple .psts and reduce to about 1GB in size.. I should notice a difference in the database size right?
Right now the mail server has no available slots for new drives.. .so I hope this will work
I really appreciate your help on this!!
We have an compliance mailbox where all sent items and received items go to. This mailbox is only access my the owners of the company and it has grown to 28GB. If I achive the whole thing down to a couple .psts and reduce to about 1GB in size.. I should notice a difference in the database size right?
Right now the mail server has no available slots for new drives.. .so I hope this will work
I really appreciate your help on this!!
Active 2 days ago
If you can remove that much email (28GB) from the database and then wait for the online defrag to run a few times, you should see a significant reduction in the size of the database. Like I said, it might take a few passes of the on-line defrag. Then if that doesn't seem to be reducing the size enough, and if you are sure that any deleted mailboxes and items have been purged, you might want to run the offline defrag process. In order to do this, you'll have to defrag the database on a different drive (one that has at least 120GB of free space), but once defragged you can move it back. Are you familiar with how to do this?
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
After hours on line I found a solution which pointed to the inherited Active Directory permissions . You have to give/allow permissions to the "Exchange trusted subsystem" for the user in the Active Directory...
If you troubleshoot Outlook for clients, you may want to know a bit more about the OST file before doing your next job. IMAP can cause a lot of drama if removed in the accounts without backing up.
In this video we show how to create a mailbox database 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 >> Data…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
Suggested Courses
Course of the Month10 days, 20 hours left to enroll
770 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.