Configuring Replication step by step in SQL Server

Configuring Replication step by step in SQL Server

Here is a video that demonstrates “Configuring Replication step by step in SQL Server”

Replication_image

Understanding SQL Server replication basics to expert level – Part-1

Understanding SQL Server replication basics to expert level – Part-2

Step by Step guide to configuring snapshot replication

Step by Step guide to configuring transactional replication

Step by Step guide to Transactional Replication with Updatable Subscriptions

Step by step guide to configuring Peer to Peer Replication

Step by step guide to configuring Merge Replication

 

Please check this article to configure SQL Server replication with screenshots.

Also learn:

How to monitor Transactional Replication?

How to monitor SQL Server replication using Replication Monitor?

Posted in High Availability, SQL Server DBA | Tagged , , , , , , , , , , , | 7 Comments

Leave a Reply

7 Comments on "Configuring Replication step by step in SQL Server"

Notify of
avatar
Sort by:   newest | oldest | most voted
trackback

maillot de foot 2013…

Im not sure the place you’re obtaining your info, but great topic. I requirements to commit some time finding out more or comprehending much more. Thanks for impressive information I was hunting for this details for my mission….

wifi hack cydia app
Guest

Hello very nice site!! Guy .. Beautiful .. Amazing .. I’ll bookmark your blog and take the feeds additionally? I’m happy to search out a lot of useful info right here within the post, we need develop more strategies in this regard, thank you for sharing. . . . . .

Instant Cash
Guest

Your site is useful. Everything is very open with a really clear clarification of the issues. It was definitely informative.

ymng1234@gmail.com
Guest

is very nice and very usegul for me

Rehan
Guest
Hi Uday, Good information on Replication. Here i have one scenario @ Transaction Replication. Kindly check the below steps and do the needful. We successfully set up transactional replication with 15 articles. After successful of article changes Done in subscriber, we need to execute “.SQL File” at subscriber database. Please help on this. Create the below table in Publisher database: Create Table DwDimTable ( Ino int Primary Key ,Item Varchar(10) ,Usage numeric(16,2) ,StartDate date ,EndDate date) Create the below table and run the query in the Subscriber database: Create table DwFactTable( Ino int, Item varchar(15), PerDayUsage numeric(16,5), [Day] int, [Month]… Read more »
wpDiscuz