Restore a Satellite for SQL Server replication - 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.1

The tasks below are for restoring and restarting global workshare for SQL Server databases. Do not deviate from the following sequence of steps. Additionally, do not proceed to a subsequent step in the workflow until the previous step is complete.

Restore the Model

  1. Stop the replication between the Host and Satellite.

  2. Make a backup of the Host.

  3. Send the backup of the Host to the Satellite.

  4. Delete the database(s) at the Satellite.

    SHARED Tip From this point on, the following steps are the same as adding a new satellite.

  5. Restore the backup of the Host.

  6. Run the script PostRestore_[N].sql (where [N] is the satellite number on the Model).

  7. Restore the peer-to-peer SQL replication between the Host and Satellite.

Restore the Catalog, Catalog Schema, Site, and Site Schema

  1. Stop the replication between the Host and Satellite.

  2. Make a backup of the Host.

  3. Send the backup of the Host to the Satellite.

  4. Delete the database(s) at the Satellite.

    SHARED Tip From this point on, the following steps are the same as adding a new satellite.

  5. Restore the backup of the Host

  6. Restore the SQL transactional replication between the Host and Satellite.