In the event that one of the locations participating in a Global Workshare Configuration (GWC) must be taken off-line, we recommend using one of the following supported workflows to ensure minimal adverse impact to the remaining locations in the GWC. Each workflow scenario presumes an initial GWC configuration of three database servers, with each server functioning as both SQL Distribution and Data Server.
For the purposes of these scenarios, the Host server is named HSVSRV1. The two Satellite servers are named HOUSRV1 and OSLSRV1.
-
Workflow Scenario 1: Restore Model as Copy
When the Host location experiences a work stoppage, we recommend using the Restore model as copy workflow to achieve a stand-alone configuration.
-
Workflow Scenario 2: Amputate and Re-Duplicate
When a Satellite server experiences a catastrophic failure, but the Host location remains in-place and operable, we recommend using the Amputate and re-duplicate workflow to restore the SQL Global Workshare Configuration.
What do you want to do?