Restore-WFFarm

Updated: August 10, 2012

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

Restore-WFFarm

This cmdlet is used in disaster recovery scenarios to set up the farm using recovered databases.

Syntax

Parameter Set: AutoCert
Restore-WFFarm -CertificateAutoGenerationKey <SecureString> -InstanceDBConnectionString <String> -ResourceDBConnectionString <String> -WFFarmDBConnectionString <String> [-AdminGroup <String> ] [-ConsistencyVerifierLogPath <String> ] [-HttpPort <Int32> ] [-HttpsPort <Int32> ] [-InstanceStateSyncTime <DateTime> ] [-RunAsAccount <String> ] [ <CommonParameters>]

Parameter Set: CustomCert
Restore-WFFarm -InstanceDBConnectionString <String> -OutboundCertificateThumbprint <String> -ResourceDBConnectionString <String> -SslCertificateThumbprint <String> -WFFarmDBConnectionString <String> [-AdminGroup <String> ] [-ConsistencyVerifierLogPath <String> ] [-EncryptionCertificateThumbprint <String> ] [-HttpPort <Int32> ] [-HttpsPort <Int32> ] [-InstanceStateSyncTime <DateTime> ] [-RunAsAccount <String> ] [ <CommonParameters>]

Detailed Description

Run Restore-WFFarm in disaster recovery scenarios to set up the farm using recovered databases.

Parameters

-AdminGroup<String>

Represents the set of users who are considered workflow administrators.

-CertificateAutoGenerationKey<SecureString>

This represents the password that will be used to securely store the auto generated certificate in the database.

-ConsistencyVerifierLogPath<String>

-EncryptionCertificateThumbprint<String>

This certificate is used for securing the SQL connection strings. If not provided, it will take the value of the SslCertificate. Represents the encryption certificate.

-HttpPort<Int32>

The port number used for HTTP communication.

-HttpsPort<Int32>

The port number used for HTTPS communication.

-InstanceDBConnectionString<String>

Represents the connection string of the gateway database.

-InstanceStateSyncTime<DateTime>

-OutboundCertificateThumbprint<String>

The certificate that will be used as the outbound certificate by Workflow Manager 1.0.

-ResourceDBConnectionString<String>

Represents the connection string of the container database for Service Bus.

-RunAsAccount<String>

Represents the account under which the service will be running.

-SslCertificateThumbprint<String>

Represents the SSL certificate used by the workflow farm.

-WFFarmDBConnectionString<String>

This represents the connection string of the database where all the configuration settings will be stored.

<CommonParameters>

This cmdlet supports the common parameters: -Verbose, -Debug, -ErrorAction, -ErrorVariable, -OutBuffer, and -OutVariable. For more information, see about_CommonParameters

Inputs

The input type is the type of the objects that you can pipe to the cmdlet.

Outputs

The output type is the type of the objects that the cmdlet emits.

Notes

• This cmdlet may timeout with a WFRuntimeSettingFailed exception. After this command is run, additional queries should be made to determine whether the operation was successful.

Examples

Example 1

Restore the workflow farm using recovered databases.

PS C:\> $CertKey=convertto-securestring 'CertificatePassword' -asplaintext-force;
Restore-WFFarm -ResourceMgmtDBConnectionString 'Data Source=SqlServerName;Initial Catalog=WfResourceDatabase;Integrated Security=True' -FarmMgmtDBConnectionString 'Data Source=SqlServerName;Initial Catalog=RecoverWFManagementDB;Integrated Security=True' -InstanceMgmtDBConnectionString 'Data Source=SqlServerName;Initial Catalog=WfInstanceDatabase;Integrated Security=True' -CertAutoGenerationKey $CertKey

Example 2

Restore the workflow farm using recovered databases.

PS C:\> $sec = ConvertTo-SecureString -Force -AsPlainText Password~1
Restore-AzureWFFarm -InstanceDBConnectionString "Data Source=localhost;Initial Catalog= WFInstanceManagementDB;Integrated Security=SSPI;Asynchronous Processing=True" -ResourceDBConnectionString "Data Source=localhost;Initial Catalog= WFResourceManagementDB;Integrated Security=SSPI;Asynchronous Processing=True" -InstanceStateSyncTime "June 28, 2012 12:30:00 PM" -ConsistencyVerifierLogPath "C:\ETH\AppFabricTemp\Textsec.txt" -WFFarmDBConnectionString "Data Source=localhost;Initial Catalog=WFManagementDB1;Integrated Security=SSPI;Asynchronous Processing=True" -Verbose -CertificateAutoGenerationKey $sec