Remove 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

Refer to your SQL Server documentation for more detailed information concerning the SQL Server steps in the following procedures.

In the following procedures, only delete the subscriptions relative to the Satellite that you want to remove. If you accidentally delete a subscription, you will have to send a backup to the other location and add the new subscription back in the Microsoft SQL Server Management Studio to recover the deleted subscription.

Delete a subscription at the Host

Repeat the following steps for each server as needed: Catalog, Catalog schema, Model, Site, and Site schema.

  1. In the Microsoft SQL Server Management Studio, select the Host server, and expand the Replication folder in the Object Explorer window.

  2. Under Replication, further expand the Local Publications folder.

  3. Right-click the subscription corresponding to the remote server to remove, and select Delete.

  4. On the confirmation message box, select Connect to Subscriber and delete record of this subscription at Subscriber also, and click Yes to confirm the deletion.

    If you do not have access to the subscriber, you cannot delete the record remotely. You have to gain access to the subscriber and remove the subscriptions from it directly.

Delete subscriptions at the Satellites

This procedure is for the Model database only.

  1. In the Microsoft SQL Server Management Studio, select the Satellite server, and expand the Replication folder in the Object Explorer window.

  2. Under Replication, further expand the Local Publications folder.

  3. Right-click the subscription corresponding to the Host to remove, and select Delete.

Delete the Unused Publication from the Satellite

  1. In the Microsoft SQL Server Management Studio, select the Satellite server, and expand the Replication folder in the Object Explorer window.

  2. Under Replication, further expand the Local Publications folder.

  3. Right-click the appropriate publication, and select Delete.

If you do not delete the publication, SQL Server will not allow you to delete or restore the database from another backup.

Remove the Global Workshare Configuration between the Host and Satellite

In Project Management, use the Tools > Consolidate Model from Workshare Command to remove the Global Workshare configuration between the Host and Satellite. See Consolidate Model from Workshare Command.