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