SQL Server
Fully backup all databases
WFInstanceManagementDB
WFManagementDB
WFResourceManagementDB
SbGatewayDatabase
SbManagementDB
SBMessageContainer01
Workflow Server
Save PrimarySymmetricKey by running Get-SBNamespace | clip
Leave the farm by running the config wizard
Uninstall the following programs
Workflow
Manager
Workflow Manager Client
Windows Fabric
Service Bus
Delete folders
C:\Program
Files\Service Bus
C:\Program Files\Workflow Manager
C:\Program Files\Windows Fabric
Download Web Platorm installer
Select
Workflow Manager 1.0 Refresh (CU2)
Do not run the configuration wizard
SQL Server
Make sure you are running SQL Server Enterprise on your SQL
Server
Delete the following databases
SbManagementDB
WFManagementDB
Workflow Server
Run as Administrator” PowerShell on first Workflow farm
server
Import-Module WorkflowManager
Set your two keys
$myKey = convertto-securestring ‘****’ asplaintext -force
$myPassword=convertto-securestring ‘Passwordtowindowsaccount’
-asplaintext -force
Restore the Service Bus farm
Update
Domain\SPFarm and DatabaseServer to your information
Restore-SBFarm
-RunAsAccount ‘DOMAIN\SPFarm’ -GatewayDBConnectionString ‘Data
Source=[DatabaseServer];Initial Catalog=SbGatewayDatabase;Integrated
Security=True;Encrypt=False’ -SBFarmDBConnectionString ‘Data Source=[DatabaseServer];Initial
Catalog=SbManagementDBNEW;Integrated Security=True;Encrypt=False’ -AdminGroup
‘BUILTIN\Administrators’ -CertificateAutoGenerationKey $myKey
Restore-SBGateway -GatewayDBConnectionString ‘Data
Source=[DatabaseServer];Initial Catalog=SbGatewayDatabase;Integrated Security=True;Encrypt=False’
-SBFarmDBConnectionString ‘Data Source=[DatabaseServer];Initial
Catalog=SbManagementDBNEW;Integrated Security=True;Encrypt=False’
Restore-SBMessageContainer -ContainerDBConnectionString
‘Data Source=[DatabaseServer];Initial Catalog=SBMessageContainer01;Integrated
Security=True;Encrypt=False’ -SBFarmDBConnectionString ‘Data
Source=[DatabaseServer];Initial Catalog=SbManagementDBNEW;Integrated
Security=True;Encrypt=False’ -Id 1
Add-SBHost -EnableFirewallRules $TRUE -RunAsPassword
$myPassword -CertificateAutoGenerationKey $myPassword -SBFarmDBConnectionString
‘Data Source=[DatabaseServer];Initial Catalog=SbManagementDBNEW;Integrated
Security=True;Encrypt=False’
Restore Workflow Manager farm
Update
Domain\SPFarm and DatabaseServer to your information
Restore-WFFarm
-RunAsAccount ‘DOMAIN\SPFarm’ -InstanceDBConnectionString ‘Data
Source=[DatabaseServer];Initial Catalog=WFInstanceManagementDB;Integrated
Security=True;Asynchronous Processing=True;Encrypt=False’
-ResourceDBConnectionString ‘Data Source=[DatabaseServer];Initial Catalog=WFResourceManagementDB;Integrated
Security=True;Asynchronous Processing=True;Encrypt=False’
-WFFarmDBConnectionString ‘Data Source=[DatabaseServer];Initial
Catalog=WFManagementDBNEW;Integrated Security=True;Encrypt=False’
-InstanceStateSyncTime ‘Friday, Jan 24, 2020 06:30:00 PM’
-ConsistencyVerifierLogPath ‘c:\temp\log.txt’ -CertificateAutoGenerationKey
$myKey -Verbose –SkipConsistencyVerification
Restore the
“PrimarySymmetricKey” and set up authorized users for WorkflowDefaultNamespace
Update spfarm@domain
and spservice@domain to your accounts
Set-SBNamespace -Name
“WorkflowDefaultNamespace” -PrimarySymmetricKey “[PrimarySymmetricKey]”
$SBClientConfiguration =
Get-SBClientConfiguration -Namespaces ‘WorkflowDefaultNamespace’ -Verbose;
Set-SBNamespace -Name
WorkflowDefaultNamespace -ManageUsers @(‘spfarm@domain’, ‘spservice@domain’)
Add Workflow Manager
farm to the Workflow Manager farm
Add-WFHost
-WFFarmDBConnectionString ‘Data Source=[DatabaseServer];Initial
Catalog=WFManagementDBNEW;Integrated Security=True;Encrypt=False’ -RunAsPassword
$myPassword -EnableFirewallRules $TRUE -CertificateAutoGenerationKey $myKey
-SBClientConfiguration $SBClientConfiguration –Verbose
Check Workflow farm
Get-WFFarm
Get-WFFarmStatus
Get-SBFarm
Get-SBFarmStatus
Connect SharePoint
site collection and the new Workflow Manager
Sharepoint Server
Register-SPWorkflowService -SPSite
“https://portal.domain.com” -WorkflowHostUri https://wfm.domain.com:12290 -force