{"id":1130,"date":"2009-10-30T12:23:52","date_gmt":"2009-10-30T10:23:52","guid":{"rendered":"http:\/\/contoso.se\/blog\/?p=1130"},"modified":"2009-10-30T12:23:52","modified_gmt":"2009-10-30T10:23:52","slug":"dpm-2010-sql-server-end-user-recovery","status":"publish","type":"post","link":"http:\/\/contoso.se\/blog\/?p=1130","title":{"rendered":"DPM 2010 &#8211; SQL Server End-user recovery"},"content":{"rendered":"<blockquote>\n<p style=\"text-align: left;\">Data Protection Manager (DPM) 2010 (currently in beta) allows backup administrators to authorize SQL Server database owners to recover their databases without intervention from the backup administrator.<\/p>\n<p>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. A DPM role for SQL Server End-User Recovery (SQL Server EUR) includes the following:<\/p>\n<ul>\n<li>Users: A security group that represents a set of end users.<\/li>\n<li>Objects: SQL Server databases that can be recovered and instances of SQL Server that have been identified for an alternate instance recovery.<\/li>\n<li>Recovery permissions for alternate instance recovery, which a DPM administrator uses for managing SQL Server EUR functionalities used by end-users.<\/li>\n<\/ul>\n<p>\u00c2\u00a0<\/p><\/blockquote>\n<p>Source: DPM 2010 beta documentation<\/p>\n<p>The first thing you need to do is to install the SQL Server end-user recovery client on the protected machine, in this example hq-opsmgr28. The EUR client application enables end-users to perform recoveries of databases.<\/p>\n<p style=\"text-align: center;\"><a href=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser01.JPG\"><img decoding=\"async\" loading=\"lazy\" class=\"size-medium wp-image-1133  aligncenter\" title=\"DPM_EndUser01\" src=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser01-300x226.jpg\" alt=\"DPM_EndUser01\" width=\"300\" height=\"226\" srcset=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser01-300x226.jpg 300w, http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser01.JPG 505w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>After that you need to create a role, that is done, in the current beta,\u00c2\u00a0with DPM Command shell. The following example creates a role named &#8220;Operations Manager SQL&#8221;.<\/p>\n<blockquote><p>$Role = New-DPMRole -name &#8220;OpsMgrSQL&#8221; -description &#8220;Operations Manager SQL&#8221; -DPMServerName HQ-DPM55<br \/>\nAdd-DPMSecurityGroup -DPMRole $Role -SecurityGroups &#8220;Hq\\OpsMgrSQL&#8221;<br \/>\n$DatabaseForEndUserRecovery = $null<br \/>\n$ListOfPGs = Get-ProtectionGroup -DPMServerName HQ-DPM55<br \/>\n$ListOfPGs | ForEach-Object {if ($_.FriendlyName -eq &#8220;SQL Protection Group&#8221;) {$PG = $_; break }}<br \/>\n$DatasourceInPG = Get-Datasource $PG<br \/>\n$DatasourceInPG | ForEach-Object {if ($_.LogicalPath -eq &#8220;HQ-OPSMGR28\\OperationsManager&#8221;) {$DatabasesForEndUserRecovery +=,$_}}<br \/>\nAdd-DPMRecoveryItem -DPMRole $Role -type SQLDatabase -datasource $DatabasesForEndUserRecovery<br \/>\nAdd-DPMRecoveryItem -DPMRole $Role -type SQLInstance -sqlinstances &#8220;HQ-OPSMGR28&#8221;<br \/>\n$RecoveryTargetInstance = New-DPMRecoveryTarget -Type SQLINSTANCE -RecoveryTarget &#8220;HQ-OPSMGR28\\Recovery&#8221; -RecoveredFilesPath C:\\TEMP<br \/>\nAdd-DPMRecoveryTarget $Role $RecoveryTargetInstance<br \/>\nSet-DPMRole -DPMRole $Role<\/p><\/blockquote>\n<p>This script will create a new role named OpsMgrSQL. It will add the security group HQ\\OpsMgrSQL to this role. Get the list of protection groups and\u00c2\u00a0all data sources in SQL Protection Group, and then add the OperationsManager database to the list of databases we want to allow the role to recover\u00c2\u00a0. Then add the\u00c2\u00a0list to the role as recovery item. Add the required instance whose database we want to recover, and\u00c2\u00a0add the target instance and recovery target. Finally we save the role.<\/p>\n<p>Members of the HQ\\OpsMgrSQL group can now connect to the DPM server HQ-DPM55 and restore the OperationsManager database (from the hq-opsmgr28 server). The OperationsManager database is protected by the\u00c2\u00a0SQL Protection Group and can be restored to the HQ-OPSMGR28\\Recovery SQL instance only.<\/p>\n<p>From the end-user recovery wizard, in the protected server, the end-user can now recover the database<\/p>\n<p style=\"text-align: center;\"><a href=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser06.JPG\"><img decoding=\"async\" loading=\"lazy\" class=\"size-medium wp-image-1142  aligncenter\" title=\"DPM_EndUser06\" src=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser06-300x125.jpg\" alt=\"DPM_EndUser06\" width=\"300\" height=\"125\" srcset=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser06-300x125.jpg 300w, http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser06.JPG 686w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>\u00c2\u00a0<\/p>\n<p style=\"text-align: center;\"><a href=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser07.JPG\"><img decoding=\"async\" loading=\"lazy\" class=\"size-medium wp-image-1143  aligncenter\" title=\"DPM_EndUser07\" src=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser07-300x157.jpg\" alt=\"DPM_EndUser07\" width=\"300\" height=\"157\" srcset=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser07-300x157.jpg 300w, http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser07.JPG 684w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>\u00c2\u00a0<\/p>\n<p style=\"text-align: center;\"><a href=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser08.JPG\"><img decoding=\"async\" loading=\"lazy\" class=\"size-medium wp-image-1144  aligncenter\" title=\"DPM_EndUser08\" src=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser08-300x112.jpg\" alt=\"DPM_EndUser08\" width=\"300\" height=\"112\" srcset=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser08-300x112.jpg 300w, http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser08.JPG 677w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p>\u00c2\u00a0<\/p>\n<p style=\"text-align: center;\"><a href=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser09.JPG\"><img decoding=\"async\" loading=\"lazy\" class=\"size-medium wp-image-1145  aligncenter\" title=\"DPM_EndUser09\" src=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser09-300x118.jpg\" alt=\"DPM_EndUser09\" width=\"300\" height=\"118\" srcset=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser09-300x118.jpg 300w, http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser09.JPG 686w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p style=\"text-align: center;\"><a href=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser10.JPG\"><img decoding=\"async\" loading=\"lazy\" class=\"size-medium wp-image-1146  aligncenter\" title=\"DPM_EndUser10\" src=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser10-300x162.jpg\" alt=\"DPM_EndUser10\" width=\"300\" height=\"162\" srcset=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser10-300x162.jpg 300w, http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser10.JPG 653w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p style=\"text-align: center;\"><a href=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser11.JPG\"><img decoding=\"async\" loading=\"lazy\" class=\"size-medium wp-image-1147  aligncenter\" title=\"DPM_EndUser11\" src=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser11-300x170.jpg\" alt=\"DPM_EndUser11\" width=\"300\" height=\"170\" srcset=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser11-300x170.jpg 300w, http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser11.JPG 606w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p style=\"text-align: center;\"><a href=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser12.JPG\"><img decoding=\"async\" loading=\"lazy\" class=\"size-medium wp-image-1148  aligncenter\" title=\"DPM_EndUser12\" src=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser12-300x203.jpg\" alt=\"DPM_EndUser12\" width=\"300\" height=\"203\" srcset=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser12-300x203.jpg 300w, http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser12.JPG 677w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p style=\"text-align: center;\"><a href=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser03.JPG\"><img decoding=\"async\" loading=\"lazy\" class=\"aligncenter size-medium wp-image-1152\" title=\"DPM_EndUser03\" src=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser03-300x202.jpg\" alt=\"DPM_EndUser03\" width=\"300\" height=\"202\" srcset=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser03-300x202.jpg 300w, http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser03.JPG 761w\" sizes=\"(max-width: 300px) 100vw, 300px\" \/><\/a><\/p>\n<p style=\"text-align: center;\"><a href=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser05.JPG\"><img decoding=\"async\" loading=\"lazy\" class=\"size-full wp-image-1149  aligncenter\" title=\"DPM_EndUser05\" src=\"http:\/\/contoso.se\/blog\/wp-content\/uploads\/2009\/10\/DPM_EndUser05.JPG\" alt=\"DPM_EndUser05\" width=\"210\" height=\"237\" \/><\/a><\/p>\n<p>\u00c2\u00a0<\/p>\n<p>The OperationsManager database is restored and back online again. Performed by the SQL administrators without any delay or wait for backup administrators.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Data Protection Manager (DPM) 2010 (currently in 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 &hellip; <a href=\"http:\/\/contoso.se\/blog\/?p=1130\">Continue reading <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0},"categories":[34],"tags":[],"_links":{"self":[{"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1130"}],"collection":[{"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1130"}],"version-history":[{"count":14,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1130\/revisions"}],"predecessor-version":[{"id":1154,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1130\/revisions\/1154"}],"wp:attachment":[{"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1130"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1130"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/contoso.se\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}