The following workflow explains a procedure for recovering a Satellite server in the Global Workshare (GWS) environment. A server can fail due to hardware or other catastrophic failure. This procedure applies to systems using SQL Server only.
-
In Microsoft SQL Server Management Studio, expand the Host server, and select Replication > Local Publications.
-
Right-click the subscription that corresponds to the Satellite location, and then click Delete. Repeat this step for the Catalog, Catalog schema, Model, Site and Site schema.
-
In the Microsoft SQL Server Management Studio dialog, select the Connect to Subscriber and delete record of the subscription at Subscriber also check box.
-
For the Model database only, delete the subscription at the Satellite.
-
Connect to the Satellite, and delete the Host subscription.
-
At the Satellite location, delete the publication that is now not used. Select Replication > Local Publications, right-click the publication that is no longer used, and then click Delete. The publication must be deleted before you can delete or restore that database from another SQL Server backup.
-
If there are any remaining subscriptions related to the failed Satellite, right-click the subscription that corresponds to the Satellite, and then click Delete.
-
In the Project Management task, run the Tools > Consolidate Model from Workshare Command. Select only the location that you want to consolidate. This location represents the one Satellite that is being replaced or repaired.
-
If the Satellite server is repaired, clean the Satellite database using the Clean Database Command.
-
If the Satellite server is a replacement computer with a different name from the failed Satellite server, delete the previous location object from within Project Management, and then create a new location object for the replacement computer.
-
Add the repaired or replacement Satellite back into the GWS using Add an additional satellite to an existing Global Workshare Configuration.