Microsoft Office Tutorials and References
In Depth Information
Configuring and using SQL self service recovery for SQL administrators
7.
On the next screen you have one more chance to review your recovery
options. Click Recover when ready.
Those are all the steps to recover database from within the DPM
Administrator Console.
Configuring and using SQL self service
recovery for SQL administrators
DPM 2010 has another new feature that allows database administrators to restore
their own SQL databases. This feature is known as self service recovery for SQL. It is
done by creating groups in the Active Directory or specifying users that can restore
certain databases and where they can restore them to. Additionally it is easy to
configure. We didn't cover this in Chapter 7 , but we are now going to look at how to
set this feature up and how to perform a restore using it.
Setting up self service recovery for SQL
We need to create a role that has the permission to recover databases. Here are the
steps to do this:
1.
Create a group in the Active Directory. We have one called SQLDBAS in
this example. Add the user accounts of your database administrators to
this group.
2.
Go to your DPM server and open the DPM Administrator Console . Click on
the Protection tab:
3.
Click on Action then select Configure self service recovery for SQL Server :
 
Search JabSto ::




Custom Search