SQL Server Replication (Part 5) : Create Subscription

After Publication has been created successfully, next we will create Subscriptions

1. Expand Folder Replication, Expand folder Local Publications, Expand PUBLICATION_VMJ (previously created), right click : New Subscription

2. Click Next

3. Choose the publication, click next

4. Choose "Run all agents at the distributor", click next

5. Click Button Add subscriber, choose Add SQL Server Subscriber

6. Specify login SQL Server on Server Backup, (make sure, you enter hostname, if IP Address, we will get error)

7. On server backup, choose new database, click next

8. Enter Database name, specify database files, click OK

9. After DB name has been specified, click next

10, click button [. . .] to specify agent security

11. Choose Run continously, click next

12. Leave as default, then click next

13. Check create the subscription(s) only, click next

14. Click Finish

15. Subscription has been created

SQL Server Replication (Part 4) : Create Publication

Let's Open SQL Server Management Studio on Server Database Primary, here step by step to create Publication :

1. Expand Folder Replication, right click New Publication

2. Click Next  

3. Choose the database, click next

4. Choose Publication Type : Transactional Publication

5. Choose objects , then click next

6. If we want to filter table rows, clik button add, if don't need, click next

7. Check first option : create a snapshot immediately , click next

8. On Agent Security, click button security settings

9. On Domain or Machine account under which the Snapshot Agent process will run, choose : "Run under the SQL Server Agent service account", on connect Publisher, specify SQL Server Login, click OK

10. Now we can see "SQL Server Agent account" on Snapshot Agent and on Log Reader Agent

11. Check only "Create the publication" and click OK

12. Specify Publication name, then click finish

13. Creating Publication success