Test defrag of database in exchange 2007 sp1

70 pts.
Tags:
Exchange 2007
Exchange 2007 SP1
Exchange Backup
Exchange Backup & Restore
Exchange databases
We do not have a test environment and I would like to make a copy of the database on storage group 1 that needs to be defraged after all the mailbox moves to other storage groups/databases. Question: What is the best way to copy and move it without taking the email system down? Question: When defraging the copied database from what I have read, I will only need to dismount it. I will not need to stop any services, is this right. Question: I am trying to determine the downtime we will have and any issues we may encounter while defraging the live db, is this the best method?
ASKED: April 13, 2009  1:56 PM
UPDATED: February 1, 2012  8:52 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

You would have to dismount the database to copy it first of all. But if you are going to move all the mailboxes out of that database there is no need to copy the database before defragging it. If it has trouble mounting after the defrag and it is empty, worst case scenario is you delete it and mount the database and a new one will be created. That actually is the fastest thing to do anyway.
As far as defragging goes, you are correct, you do not have to stop any services to dismount and defrag a mail store.
As far as downtime, again if you have moved all mailboxes out of that store then there will be no downtime to the end users while that database is being defragged (at that point just delete it and re-mount the store to create a new one, why waste time defragging it at all?) If there are mailboxes in the store then the downtime depends on the size of the database and how much white space is going to be reclaimed. I can’t give you a rule of thumb here. Too many variables, including how many processors, how much memory, how much throughput on the system during the planned defrag etc. The larger the database the longer a defrag will take, that much I can tell you. Try to keep your mailstores to a reasonable size, 60GB or less is a reasonable size.

=================
First, you have to be careful of performing transfer of database to another database. You can use a third party defragmentation software which has the feature of defragging your database. However, I think it would be better if you will hire a professional programmer before you do the defragmentation yourself.

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • Jpeevey
    The issue is I need to know the estimated downtime it will take to plan, that is why I thought I would make a copy to test the downtime. From the above email I understand I would need to dismount the database I want to copy. The size of the db is around 100GB and I would need to copy it to another storage group. Then remount the original database and defrag the copied database that I copied into the other storage group. Has anyone copied a db this size? Thanks
    70 pointsBadges:
    report
  • Fontanatech
    I just ran a defrag last saturday on a 68gb priv1.edb and it took 12 hours. I wrote about my experience a little bit at blog.jimmystewart.me if you are interested...
    265 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following