Categories
High Availability

Transactional Replication – Configure Subscriber

Unlike previous versions, of SQL Server 2005 allows you to use the same wizard to create either pull or push subscriptions. Perform the below steps to Configure Subscriber

Categories
High Availability

Transactional Replication – Configure Publication

Once youve configured a distributor, youre ready to create publications. Perform the below steps as follows,

Step1 : Connect to an instance (Sansu) of SQL Server by using the SQL Server Management Studio (SSMS), navigate to the “replication” folder then local publications folder, right-click this folder, and select New Publication. This invokes the new publication wizard and if you dont ever want to see this screen again, simply check the option to skip the introductory screen in the future.

Categories
High Availability

Transactional Replication – Configuring Distributor

Lets Discuss the steps to Configure Distributor in detail.
In this article I am using the Server SansuTest as the Distributor. The Distributor is configured from SSMS as follows :

Categories
High Availability

Replication Components and Agents

Replication Components

SQL 2005 replication is based on the Publish and Subscribe metaphor. Let us look at each of the individual components in detail.