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.
Solved
Exchange 2000 offline defrag of 1 store while 2 stores online
Posted on 2006-07-18
I have an exchange server with 60GB mailboxstore \ 2 GB mailboxStore \ 5Gb mailboxstore... I have 3 GB left.
I moved all the mailboxes from to the smaller stores. Now since this is the default one, I do not want to delete it. so I was thinking of offline defrag..... I need to do this while the other two are still online. This is what I plan to do, please let me know if I need something else:
1) dismount the mailboxstore 60GB (which is the one I want to defrag)
2) Copy Priv1.* to another machine with plenty of space and run eseutil /d /p <database name>
3) Once done. I will rename the orig to .old or something and copy the new files which should be very small to the original location.
4) Mount the mailbox store back.
The question is, would the other stores be ok and remain online with no issue. Do I have to do anything with the transaction logs. Would the store mount in this case.
Thanks,
I moved all the mailboxes from to the smaller stores. Now since this is the default one, I do not want to delete it. so I was thinking of offline defrag..... I need to do this while the other two are still online. This is what I plan to do, please let me know if I need something else:
1) dismount the mailboxstore 60GB (which is the one I want to defrag)
2) Copy Priv1.* to another machine with plenty of space and run eseutil /d /p <database name>
3) Once done. I will rename the orig to .old or something and copy the new files which should be very small to the original location.
4) Mount the mailbox store back.
The question is, would the other stores be ok and remain online with no issue. Do I have to do anything with the transaction logs. Would the store mount in this case.
Thanks,
[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
What you have here sounds ok to me, If you dismount one store i.e. the 60GB store it will have no affect on the other stores. This is one of the benefits of having multiple stores so that you can complete maintenance or restores that do not affect every user. One thing I always reommend it to complete a backup first. I'd make sure you have a known good backup of all stores NTBackup will do the job. I normally wouldn't recommend completing this during business hours either just in case something does go wrong. Its unlikely but things do happen. The transaction log files will sort themselves out when you do a backup of the stores they will be committed to the database.
This is a good article with step by step info - http://www.petri.co.il/defragment_exchange_2000_2003_server_databases.htm
This is a good article with step by step info - http://www.petri.co.il/defragment_exchange_2000_2003_server_databases.htm
So the exchange services will remain running, only the default mailbox store will be offline. the other two will remain online while the defrag is taking place on a different server.
Once the defrag is done, I will copy it over and mournt the mailboxstore back online (while the other two are running)
Q2. Backup takes about 12hours to run.... this store has nothing on it except the system attendant. (do have I have to do an offline defrag or can I not dismount it, rename the priv1.* to Priv1old.* and mount it.... would that mess things up. (just a thought) I have nothing on there anyway.
should I use esutil /d /p priv1.edb
Once the defrag is done, I will copy it over and mournt the mailboxstore back online (while the other two are running)
Q2. Backup takes about 12hours to run.... this store has nothing on it except the system attendant. (do have I have to do an offline defrag or can I not dismount it, rename the priv1.* to Priv1old.* and mount it.... would that mess things up. (just a thought) I have nothing on there anyway.
should I use esutil /d /p priv1.edb
YIf you want to re-claim the white space in the sotre and keep this store then you need to complete the defrag. To be honest if your aim is to remove this store in the end anyway I would simply let the backup run on the next schedule, dismount it, if you must to free space move the associated files for that particular store to a temp location and then monitor and test everything. If you have no issues after say 10-15 days you can pretty much say that you should be ok to delete the store.
This has some info on deleting stores. It refers to a front end server but its the same principle. If you dismount the store and see no issues then you can be pretty safe to delete it but as I said test and onitor before hand especially since your still running Exchange 2000.
http://www.microsoft.com/technet/prodtechnol/exchange/guides/E2k3SecHardGuide/226dbfa1-a75c-4d01-bdde-14321b22b743.mspx?mfr=true
This has some info on deleting stores. It refers to a front end server but its the same principle. If you dismount the store and see no issues then you can be pretty safe to delete it but as I said test and onitor before hand especially since your still running Exchange 2000.
http://www.microsoft.com/technet/prodtechnol/exchange/guides/E2k3SecHardGuide/226dbfa1-a75c-4d01-bdde-14321b22b743.mspx?mfr=true
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article lists the top 5 free OST to PST Converter Tools. These tools save a lot of time for users when they want to convert OST to PST after their exchange server is no longer available or some other critical issue with exchange server or impor…
A list of top three free exchange EDB viewers that helps the user to extract a mailbox from an unmounted .edb file and get a clear preview of all emails & other items with just a single click on mailboxes.
In this Micro Video tutorial you will learn the basics about Database Availability Groups and How to configure one using a live Exchange Server Environment.
The video tutorial explains the basics of the Exchange server Database Availability grou…
This video discusses moving either the default database or any database to a new volume.
Suggested Courses
Course of the Month9 days, 4 hours left to enroll
721 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.