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!