Recover SQL
Applies To: System Center 2012 - Orchestrator, System Center 2012 R2 Orchestrator, System Center 2012 SP1 - Orchestrator
The Recover SQL activity is used to configure a runbook that recovers a SQL database to its original location or to a network folder.
Be aware that the term Network Folder is used in this integration pack in the same way that it is used in the Data Protection Manager user interface. Choosing Network Folder recovers to a local path on a production server. Therefore, the selection of Network Folder requires the name of a production server and a local path on that production server. Also be aware that recovery to any SQL Instance is not a supported activity for this integration pack because Data Protection Manager does not support this scenario through its PowerShell API.
For the procedure to configure this object, see: Configuring the Recover SQL Activity.
The following tables list the properties and published data for this activity. The activity publishes all the data from the required and optional properties into published data.
Recover SQL Properties
| Element | Description |
|---|---|
Data Source ID |
The unique identifier (GUID) of the SQL database to be recovered |
Recovery Type |
Recover to Original Instance or Recover to Network Folder |
Recovery Source ID |
The unique identifier (GUID) of the SQL database backup up point to be restored |
Recover SQL Optional Properties
| Element | Description |
|---|---|
Copy Log Files |
True or False |
Database State |
Leave database operational or leave database non-operational but able to restore additional transaction logs |
Log File Copy Location |
The location where the log files will be copied, if specified |
Restore Security |
Apply security settings of the destination computer or apply the security settings of the recovery point version |
Target Location |
The target location for the recovery |
Target Server Name |
The name of the target server for the recovery |
Recover SQL Published Data
| Element | Definition |
|---|---|
Copy Log Files |
True or False |
Data Source ID |
The unique identifier (GUID) of the SQL database to be recovered |
Database State |
Leave database operational or leave database non-operational but able to restore additional transaction logs |
EndTime |
The end time of the recovery, in the format mm/dd/yyyy hh:mm:ss AM or PM |
JobCategory |
The job category |
JobDefinitionId |
The unique identifier (GUID) of the job definition |
JobID |
The unique identifier (GUID) of the job |
Log File Copy Location |
The location where the log files will be copied, if specified |
ProtectedGroupID |
The unique identifier (GUID) of the protection group |
Recovery Source ID |
The unique identifier (GUID) of the SQL database backup up to be restored |
Recovery Type |
Recover to Original Instance or Recover to Network Folder |
RetryAttemptNumber |
The number of recovery retries attempted |
StartTime |
The start time of the recovery, in the format mm/dd/yyyy hh:mm:ss AM or PM |
Status |
Status |
Target Location |
The target location for the recovery |
Target Server Name |
The name of the target server for the recovery |
Configuring the Recover SQL Activity
To configure the Recover SQL activity
From the Activities window, drag a Recover SQL activity to the active runbook. Double-click the Recover SQL activity icon.
On the Properties tab, click the ellipsis button (...), and select the Name of the Data Protection Manager computer that you want to connect to with this activity.
In the Properties section, the properties required to define the activity are listed. Select a property in the list, and enter a value for the property. Or, to automatically populate the value from the data published by any previous activity in the runbook, right-click the property box, point to Subscribe, and then click Published data. Click the published data element you want to use, and then click OK.
The Recovery Type property has two options:
When the Recover to Network Folder option is used, the optional property Restore Security can be used. If not specified, this property defaults to Apply security settings of destination computer.
When the Recover to Original Instance option is used, the optional properties Database State and Copy Log Files can be used. If not specified, Database State defaults to Leave database operational and Copy Log Files defaults to False. For more information about the Copy Log Files option, see the Log Files section.
To use additional properties, click Optional Properties. In the Add/Remove Property dialog box, select the properties you want to apply to this activity from the Available list, and then click the right arrow button (>>). The properties appear in the Selected list. To remove a property from the Selected list, click the property, click the left arrow button (<<), and then click OK.
To automatically populate the value for the additional properties from the data published by any previous activity in the runbook, right-click the property box, point to Subscribe, and then click Published data. Click the published data element you want to use, and then click OK. For a list of the data elements published by each activity, see the Published Data tables in the activity topic.
For information about the settings on the General and Run Behavior tabs, see Common Configuration Instructions for all Activities.
Click Finish.
Log Files
When you create a recovery point by using express full backup and leave the database non-operational but able to restore additional logs, the Copy Log Files option is disabled. The Copy Log Files option is available only when you create a recovery point by using incremental backup. To copy log files in this configuration, perform the following procedure.
To copy log files when the database is set to non-operational but able to restore additional logs
On the Data Protection Manager server, create a protection group to protect the data source. Set Replica Creation to Now.
Create a recovery point for the data source. Select Create a recovery point by using incremental backup.
Configure the Recover SQL activity:
Enter a valid Data Source ID and Recovery Source ID
Set Recovery Type to Recover to Original Instance.
Select Leave database non-operational but able to restore additional transaction logs.
Select Copy SQL transaction logs between the selected recovery point and latest available recovery point.
Enter or browse for a Copy Destination for the log files.
Other Activities
The Integration Pack for Data Protection Manager contains the following additional activities: