SQL Server – How to Setup SQL Server Replication – Part 0 of 4
Introduction
This document describes a scenario how to setup the Transactional SQL Server Replication. Before we proceed for Replication setup you can read brief note about “Understanding of Replication”
http://varindersandhu.in/2011/05/14/understanding-of-replication/
Here we will setup the Transactional SQL Server Replication between SQL Server 2000 and SQL Server 2008R2.
Pre-requisite
- SQL Server 2000
- SQL Server 2008R2
This document describes below points
- Configure the SQL Server Agent
- Setup and configure a SQL Server 2000 as a main Publisher/Distributor
- Setup and configure the Publication on SQL Server 2000
- Setup and configure Subscription on SQL 2008R2
Download full document as PDF version
Pingback: SQL Server Replication – Setup and configure a SQL Server 2000 as a main Publisher/Distributor – Part 2 of 4 | Varinder Sandhu
Pingback: SQL Serever Replication – Setup and configure the Publication on SQL Server 2000 – Part 3 of 4 | Varinder Sandhu
Pingback: SQL Serevr Replication – Setup and configure Subscription on SQL 2008R2 – Part 4 of 4 | Varinder Sandhu