Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


Restore corrupt database Exchange 2010 DPM 2012

Posted on 2014-02-03
Medium Priority
Last Modified: 2014-03-11
I have an Exchange 2010 DAG environment. Backups are performed with DPM 2012. I want to simulate/test a recovery of a corrupt database in our lab environment.

All of the articles i have found refer to a single mailbox restore...which means the original DB is up and running without error. The database is restore to a recovery database, then the mailbox in question is extracted and restored to the existing database.

This is not what i want to do. I want to restore an entire failed database in my DAG environment. None of the articles, including the microsoft DPM 2012 administrator guide, cover the topic of restoring the failed database.

if anyone had done this, or knows of a complete doc i would appreciate it.
Question by:citsadmins
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
  • 3
  • 2

Expert Comment

ID: 39829696
Basic First Wild Guess Answer - We have DAG and use DPM also. It's my understanding that in a disaster recovery, since the remote Exchange Database will be offline, the general concept is that we will go to the location with the replicated Database, and simply mount it. It is possible this will fall to me in our organization, and that is what I plan to do.

Author Comment

ID: 39867271
thanks for your response dalberson. If the active copy of a DB becomes corrupted on one of the servers in your DAG, it will automatically mount one of the passive copies of that DB on one of the other servers based on your activation preference. Then you can reseed the failed copy of the DB right from the management console.

What i am trying to simulate is a total loss or corruption of all copies of one DB where the only way to recover would be a full restore from DPM.

I think all i need to do is check "this database can be overwritten by a restore" in the DB properties page/maintenance tab in the EMC. And then run the restore thru the DPM console. Very simple and straightforward...unless its not...which is what I was hoping to get some feedback on before I run thru the simulation.

Doesn't look like anyone other than you and me has any further input. I am going to run thru it with the instructions i have and see how it comes out. I will post a follow up with my results and any other issues/resolutions, as well as a step by step for anyone else needing this in the future.

thanks for you input...I'll get back to you.

Expert Comment

ID: 39870955
Cool. I look forward to hearing about the outcome.

Accepted Solution

citsadmins earned 0 total points
ID: 39910004
Follow the link below for the recovery steps in DPM.  It was very simple. (how unusual for Microsoft)

Only thing I did different in order to simulate a total DB failure, was to remove the DB copies on two of my DAG servers, then  I deleted/renamed some files from the mailbox store for the DB in question. This left me with one copy of the DB, which was unrecognizable to exchange.

I restored the DB on that server and then recreated the copies on the other two servers.


How to recover a database to its original location

   1.  On the server to which the database will be recovered, configure the target database to allow it to be overwritten by the recovered data.

      a. Go to Organization Configuration/Mailbox/Database management tab.

     b. Open properties for DB in question

     c. On Maintenance tab check the box for "this Database can be overwritten by a restore"

   2.  In DPM Administrator Console, click Recovery on the navigation bar.

   3. Using the browse functionality, select the database to recover.

   4. On the Recovery time menu, select Latest.
         ( You must select the most recent recovery point to recover the storage group to its original location)

   5.  In the Actions pane, click Recover.

   6.  The Recovery Wizard starts. The wizard options will vary depending on the version of Exchange.

    7. On the Review recovery selection page, click Next.

    8. Select Recover to original Exchange Server location, and then click Next.

    9. On the Specify recovery options page, you can select Send an e-mail when this recovery completes.

   10. On the Summary page, review the recovery settings and then click Recover.

   11. After recovery completes open the EMC on one of the exchange servers, go to Organization configuration/mailbox/database management tab and highlight the DB in question on the upper screen. click anywhere in the database copies tab in the lower screen and hit F5 to refresh. You should see one copy of the database, mounted and active on the server. (if not you will need to do further research to figure out the issue)

   12. Copy the database to the two other DAG member servers. (also known as seeding the database)

          a. make sure target servers have the same HD volume configuration/drive letter.

          b. on the EMC (same location as step 11) right click the DB and select "add mailbox database copy"

          c. Browse to the server node you want to copy to

         d. Select the activation preference

          e. click Okay/finish

13. After copy process completes refresh the database copy screen again. you should now see a second copy of the database located on the second server. it will be inactive and copy status should be "healthy".

14. repeat steps 12 and 13 to create another copy on the 3rd server.

that completes the process.

Author Closing Comment

ID: 39919980
No other input was received from other users. The process i have laid out here solved my problem completely

Featured Post

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!

Question has a verified solution.

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

When you are trying to access the server, have you ever encountered "The terminal server has exceeded the maximum number of allowed connection" error?  or "The user is attempting to log on to a Terminal Server in Remote Administration mode, but the …
I have put this article together as i needed to get all the information that might be available already into one general document that could be referenced once without searching the Internet for the different pieces. I have had a few issues where…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …

618 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