What is Replication ?
Replication is the mechanism for creating and maintaining multiple copies of the same data. Replication allows,
• Multiple copies of data can be kept in sync.
• Allows data be closer to users, improving performance.
• Allows a branch office to work when not connected to the main office.
• Separate process and offload work from production servers
What are the Components of Replication
Following are the important components in replication setup
• A publication contains articles.
• The publisher either distributes the magazine directly or uses a distributor.
• Subscribers receive publications to which they have subscribed.
What are the Server Roles Involved in Replication ?
SQL Servers can be assigned three different roles in a replication topology:
• Publishers create and modify data.
• Distributors store replication-specific data associated with one or more publishers.
• A subscriber holds a replica copy of the data.
What are the type of replication available in SQL Server ?
SQL Server supports
- Snapshot replication sends the entire data set to the subscriber.
- Transactional replication only sends modifications to the data.
- Merge replication items are modified at both the publisher and subscribers.
- Heterogeneous replication allows access to other database products.
- Peer to Peer Transactional Replication
Hi everyone
I m young in SQL Server 2008 and i dont have any experience yet, how could i grow up and build my carrier in the field. bolombelo@gmail.com for more advice.
Firstly Thanks for these videos,
Can you share some troubleshooting scnerio’s or interview questions for replication pleaseeee..
Shell we have a video on Configuring web synchronization for Merge replication using SQL Server 2008 Developer edition as publisher, distributor and SQL Express 2008 R2 instances as remote subscribers and the data additions in remote subscribers should get appended to the publisher database tables.
very usefull
is there rest fr this article?
Thanks for thre videos and sharing.
I want to ask something. I did exactly like in the
Transactional Replication videos on different Sql servers on different machines. Users have all access to each other sql servers and repl_data folder.but at the end of the subscription process , subscriber
do not have the replicated tables.
Could you help me with my problem?
Thanks in advance.
have you started the agents and ensured that SQL Server agent is in running state ?