Share via

SQL Server Replication

  • Article

Replicating a database 

In order to create replication for a database, create a new publication as shown in the figure.

  1. Create publication on the publisher server.
  2. Create subscription on either subscriber (in case of pull based subscription) or on the publisher ( in case of push based subscription).

 

 

Here SERVER1 can be distributor or it can also be on some other machine. For example purposes, SERVER1 is itself kept as publisher and distributor but in most real time scenarios, publisher, distributor and the DR-database are different physical machines.

Once the publication is created, create the subscription. The gui based steps for creating subscription are given below:

 

Specify whether the subscription is pull based or push based. Push based communication is used when