Recover from Satellite failure - Intergraph Smart 3D - Administration & Configuration - Hexagon PPM

Intergraph Smart 3D Global Workshare (SQL Server)

Language
English
Product
Intergraph Smart 3D
Subproduct
Global Workshare
Search by Category
Administration & Configuration
Smart 3D Version
13

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.

  1. In Microsoft SQL Server Management Studio, expand the Host server, and select Replication > Local Publications.

  2. 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.

  3. In the Microsoft SQL Server Management Studio dialog, select the Connect to Subscriber and delete record of the subscription at Subscriber also check box.

  4. For the Model database only, delete the subscription at the Satellite.

  5. Connect to the Satellite, and delete the Host subscription.

  6. 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.

  7. If there are any remaining subscriptions related to the failed Satellite, right-click the subscription that corresponds to the Satellite, and then click Delete.

  8. 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.

  9. If the Satellite server is repaired, clean the Satellite database using the Clean Database Command.

  10. 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.

  11. Add the repaired or replacement Satellite back into the GWS using Add an additional satellite to an existing Global Workshare Configuration.