Setting up Transactional Replication in SQL Server 2008 R2.

8.        A new window appears as shown in the screen capture below.

  

9.       Specify the distribution agent to run under the SQL Server Agent Service Account. Also connect to the distributor as well as the subscriber by impersonating the process account. Please refer the screen capture below.

10.   Click on the OK button as shown in the screen capture above.

11.   Click on the Next> button as shown in the screen capture below.

12.   Ensure that the Agent is scheduled to Run Continuously and then click on the Next> button as shown in the screen capture below.

13.   Ensure that the Subscriber is initialized immediately and then click on the Next> button as shown in the screen capture below.

14.   Click on the Next> button as shown in the screen capture below.

15.   Click on the Finish button as shown in the screen capture below.

16.   This creates a subscriber for the corresponding publisher.

17.   Expand the publisher node and you shall be able to view the subscriber as shown in the screen capture

Thus, we have successfully set the Transactional Replication in SQL Server 2008 R2.

Pages: 1 2 3




Array

No comments yet... Be the first to leave a reply!