MS SQL Server Replication Job Wizard

To start the Replication Job Wizard for a new MS SQL Server replication job, click on the New Replication Job toolbar action button, or select New Replication Job menu item from the Job menu.  You can edit an existing Replication Job by selecting a job and clicking the Edit Replication Job menu item under the Job menu which will start the Replication Job Wizard in Edit mode.

The Replication Job Wizard comprises the following steps:

Step 1 - Select Replication Type & Job Name

Step 2 - Configure Primary & Target Data Sources

Step 3 - Select the Primary Data Source & Database

Step 4 - Configure the Backup Settings & Schedule

Step 5 - Configure Target Databases

Step 6 -Save Settings & Optionally Perform Initial Full Backup