Microsoft Office Tutorials and References
In Depth Information
Restoring SQL databases with DPM
9.
Specify a temporary directory on the SharePoint web front end to store the
recovery data:
10. Choose one of the recovery options and click Next . Once again you can
set the network bandwidth usage throttling, SAN-based recovery, and
e-mail notification.
11. Review your recovery settings, and click Recover .
That is it. You recovered data in SharePoint using DPM. Remember, these steps will
work for recovering any object data in SharePoint except for entire farms.
Restoring SQL databases with DPM
DPM backup of SQL databases and restore of SQL data is easy right out of the
box with little configuration on your SQL servers. As mentioned before, DPM
2010 can protect SQL databases at the instance level allowing DPM to protect any
databases that are added to that instance automatically. The beauty of this is that
your databases will be added automatically and the recovery process is pretty
straightforward. DPM 2010 also has the ability to let your database administrators
perform their own restores. We will cover this as well.
SQL database recovery
As mentioned previously, restoring SQL data in DPM is a simple process. You can
restore to the original instance, a different instance, tape, or to a share on the network.
This is possible because DPM allows recovery of SQL server databases at the instance
level. The following steps will demonstrate how to recover a SQL database:
1. Open the DPM Administrator Console . Click on the Recovery tab.
2. Under Protected data browse the SQL server you want to recover data from.
Expand the SQL instance to see all of the protected databases:
 
Search JabSto ::




Custom Search