次の方法で共有


Recover SQL

適用対象: System Center 2012 - Orchestrator, System Center 2012 SP1 - Orchestrator

The Recover SQL activity is used in 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.

The activity publishes all of the data from the required and optional properties into published data. The following tables list the required and optional properties and published data for this activity.

Recover SQL Required Properties

Element

Sample value

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

Sample value

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

Sample value

EndTime

The end time of the recovery, format as 0001-01-01T00:00:00

JobCategory

The job category

JobDefinitionId

The unique identifier (GUID) of the job definition

JobID

The unique identifier (GUID) of the job

RetryAttemptNumber

The number of recovery retries attempted

StartTime

The start time of the recovery, format as 0001-01-01T00:00:00

Status

Status

参照:

概念

System Center 2012 Data Protection Manager Activities
System Center Integration Pack for System Center 2012 Data Protection Manager