none
DPM Self Service Recovery Tool does not list clustered SQL instances RRS feed

  • Question

  • I am running DPM 2012 w/SP1 to backup my SQL Server 2008 clustered instances.  I have configured a Self Service Recovery role on the DPM server to allow our SQL administrator to do SQL database restores.  I was able to configure the Self Service Recovery role to include all the SQL instances I am backing up with DPM (non-clustered and clustered).  However, when I use the DPM Self Service Recovery Tool I only see the non-clustered SQL instances and not the clustered ones.

    When I created the DPM Self Service role I specified the clustered SQL instances as <FQDN of the resource group>\<SQL virtual name>\<SQL instance>.  Otherwise, I would get an error saying that the SQL Instance could not be found.

    Anyone know how to get the clustered SQL instances to show up in the DPM Self Service Recovery Tool?

    Cheers,

    Rene

    Tuesday, March 26, 2013 5:27 PM

Answers

  • I figured it out...  It turns out the requirements for syntax of a SQL cluster instance in the DPM Self Service Recovery Tool is different depending on which part of the wizard you are in.

    To resolve this I had to specify the SQL cluster instances in the following manner when creating the DPM Self Service Recovery role.

    On the "Specify Recovery Items" page of the wizard:

    1. In the "SQL Server Instance or Availability Group" column, enter the SQL cluster instance as <FQDN of the resource group>\<SQL instance>.  For example: SQLvirtualname.SQLservername.domain.com\SQLinstance
    2. In the "Database Name" column, specify each database you wish to include in the Self-Service recovery role scope.  If you leave this blank it will give you an error.

    On the "Specify Recovery Target Locations" page of the wizard (configuring this is optional):

    1. In the "SQL Server Instance" column, enter the SQL cluster instance as <FQDN of the resource group>\<SQL virtual name>\<SQL instance>.  For example: SQLvirtualname.SQLservername.domain.com\SQLvirtualname\SQLinstance
    2. You can leave the "Recovered Files Path" column blank if you wish.

    NOTE: On the "Specify Recovery Items" page of the wizard, if you enter the SQL cluster instance as <FQDN of the resource group>\<SQL virtual name>\<SQL instance> and leave the Database Name field blank, it will accept that and not give you an error.  However, when you try and use the DPM Self-Service Recovery Tool you will not be able to see your SQL cluster instance in the "SQL Server Instance Name or Availability Group" drop down list (hence the reason for my original question).

    Cheers,

    Rene

    • Marked as answer by rizquierdojr Tuesday, March 26, 2013 10:25 PM
    Tuesday, March 26, 2013 10:25 PM