DPM 2010 and SQL End user Recover
The System Center Data Protection Manager (DPM) 2010 allows backup administrators to authorize SQL Server database owners to recover their databases without intervention from the backup administrator.
To do this, the DPM administrator must create and manage DPM roles. A DPM role allows backup administrators to control what an end-user can recover and which instances of SQL Server they can recover to.
in this article I will show you how to use SQL End User Recovery.
First of all you need to create a security group in AD , that Security Group will represent the set of SQL Server users, in this article it is Gomaalab\DBAJ
in the protection Group in the right hand side click on SQL end user recovery,
in welcome Window click Next
In the Specify Security groups , you need to name the Role, then you click on the add button to select the security Group from AD Gomaalab\DBAJ, then click Next
in the Specify Recovery Items , you need to specify the server name and the database name , if you want to allow all the database in that SQL server leave the Database Name field empty.then click Next
in the specify recovery targets , you have the option to allow users to recover to another database instance of not by checking the first check box
then you need to specify which server to be a recvery located , and also you have the option to restrict where they can restore the data on the server
then in the Summary windows click Next
in the end you will receive a confirmation message that the role has been created
Thanks
Islam Gomaa
Islam @ IslamGomaa.com