DPM 2010 Offers End User Recovery for SQL Server
System Center Data Protection Manager (DPM) 2010 Beta 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.
DPM role for SQL Server End-User Recovery (SQL Server EUR) includes the following:
· Users: A security group that represents a set of end users.
· Objects: SQL Server databases that can be recovered and instances of SQL Server that have been identified for an alternate instance recovery.
Recovery permissions for alternate instance recovery, which a DPM administrator uses for managing SQL Server EUR functionalities used by end-users.
end-users must use SQL Server EUR Client to perform recoveries of SQL Server databases that are backed up by a DPM server. To perform recoveries, the DPM administrator must provide SQL Server EUR permissions to end users on the DPM server.