SQL Server DBA Tutorial 102-How to Create Transactional Replication in SQL Server

In this video you will learn how to create Transactional replication in SQL Server using SQL Server management studio as well as using T-SQL script. You will also learn how to configure the publication for transactional replication, best practices of configuring publications for Transactional replication, how to add database and it's articles in Transactional replication, configuring Publication agent security and best practices of security configuration of Publisher as well as Subscriber.
It also briefly talk about what exactly is publisher, distributor and subscriber in replication in SQL Server and what is replication in sql server and replication components in SQL Server as well as consideration of Transactional Replication.

Blog link for this post

Visit our website to check out SQL Server DBA Tutorial Step by Step

[ericrouach]

Great content as always. Thanks a lot!

[zimspace]

powerful video keep th good work... thank you techbrothers

[venkatk]

Thank you very much TechBrothers for your efforts. truly appreciate your kindness.God bless you.

[deepikajoshi]

Need one help... Is there any way to pause replication and i can refresh subscriber full database and then resume replication

[trolldicker]

What are the factors that cause replication latency. We ate experiencing this issue a lot.

[adeanjy]

Can I replicate on SQL Server Instances across two different Servers? Also does this slow down the performance of a Production environment?

[_Szakal]

Hi i have source sql server where there are views. I just have access to those views. I cannot configure that sql server etc. I have also another sql server where i have full control and the ke ypoint is i have to somehow create tables which will be replication of those views from source sql server. I need to have the data on the second sql server always with same data as is on source views... so if any update on source on second sql server somehow tables data has to be reflected. Is there anyway to configure that second sql server to reach the goal?

[alexanderalto]

thanks for the great presentation, I'm new to mssql server, I would like to inquire if there is a type of replication where the generated transaction logs on the hourly basis can be applied automatically on the secondary db server?

[aragorn]

If I need to configure replication high availability for less than 1 TB database, is it best to set up as transactional or peer-to-peer in terms of ease of configuration as well as maintainability?