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
-
Stop the replication between the Host and Satellite.
-
Make a backup of the Host.
-
Send the backup of the Host to the Satellite.
-
Delete the database(s) at the Satellite.
From this point on, the following steps are the same as adding a new satellite.
-
Restore the backup of the Host.
-
Run the script PostRestore_[N].sql (where [N] is the satellite number on the Model).
-
Restore the peer-to-peer SQL replication between the Host and Satellite.
Restore the Catalog, Catalog Schema, Site, and Site Schema
-
Stop the replication between the Host and Satellite.
-
Make a backup of the Host.
-
Send the backup of the Host to the Satellite.
-
Delete the database(s) at the Satellite.
From this point on, the following steps are the same as adding a new satellite.
-
Restore the backup of the Host
-
Restore the SQL transactional replication between the Host and Satellite.