Video : How to Setup Replication with SQL Server 2008 ?

Leave a comment (7) Go to comments

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

  1. Snapshot replication sends the entire data set to the subscriber.
  2. Transactional replication only sends modifications to the data.
  3. Merge replication items are modified at both the publisher and subscribers.
  4. Heterogeneous replication allows access to other database products.
  5. Peer to Peer Transactional Replication



d/show_ads.js">

How to Setup Snapshot Replication ?

This video demonstrates

  1. How to configure Snapshot Replication between two instances of SQL Server 2008.
  2. How to Create a Publisher database
  3. How to Create a Subscriber database
  4. How to Select replicable SQL Server database objects
  5. How to Configure security for the replication processes

Step by Step video guide for setting up Replication between two instances of SQL Server 2008.

 

Video : Setting up Snapshot Replication between two instances of SQL Server 2008

How to Setup Transactional Replication ?

This video demonstrates

  1. How to configure Transactional Replication between two instances of SQL Server 2008.
  2. How to Create a Publisher database
  3. How to Create a Subscriber database
  4. How to Select replicable SQL Server database objects
  5. How to Configure security for the replication processes

Step by Step video guide for setting up Transactional Replication between two instances of SQL Server 2008.

 

Video : Set up transactional replication

How to Setup Peer to Peer Transactional Replication ?

This video demonstrates how to set up Peer to Peer transactional Replication

Video -  SQL Server 2008 Peer to Peer Replication


References

Peer-to-Peer Transactional Replication

 

Note: To view All this Video, Please install Microsoft Silver light

EOF - Video : How to Setup Replication with SQL Server 2008 ?, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000
Leave a comment

7 Comments.

  1. That’s a skillful answer to a dfificlut question

  2. Junior Eliba BOLOMBELO

    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.

  3. Firstly Thanks for these videos,
    Can you share some troubleshooting scnerio’s or interview questions for replication pleaseeee..

  4. 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.

  5. very usefull
    is there rest fr this article?

  6. 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.

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.