Replication in SQL server - Part 3 || Transactional Replication in SQL server || Ms SQL

Transactional replication typically starts with a snapshot of the publication database objects and data.

As soon as the initial snapshot is taken, subsequent data changes and schema modifications made at the Publisher are usually delivered to the Subscriber as they occur (in near real time).

Other HA-DR

[ramukomera]

Hi Dear Robin Hood. Thanks for the video and one request from my side is that plz make videos on errors and solutions for all the HA&DR concepts....Love this call you true ROBIN HOOD bcz many institutes looting thousands from every aspirants for this subjects...You are sharing knowledge for free like looting rich and giving to poor like a robin hood.... All the best bro....Love your explanation and clarity in approaching the concept... May god bless you.... Brother 😘💓💟👌

[showyou]

As Ramu said, yes you are real Robin Hood plz make videos on errors and solutions for all the HA&DR concepts

[ajitlad]

Great- thanks for video. nice explanation.

[mykamalyoutification]

Hi, how to do SQL DB replication for No-primary key tables? Do we have any work around? Kindly let us know.

[remmykesh]

Hi, I just came across your channel and I have since then subscribed to it. I love the view video that I have watched and I must commend you for a great job. However, I will like to ask if you have any video where you treat Stored procedure . Thank you

[jeevakishore]

Hi,
I have doubt.db count is not showing properly in replication configuration and the error is replication agent encountered a file compression library error while calling.it is happening very frequently.could you tell me the reason why.

[naturevibezz]

I am getting the error in the distributor to subscriber history as 'Column name or number of supplied values does not match table definition'

[spkdba]

I have one issue
distributer to subscriber data not moving
it does not show any errors like SQL server logs and distributer logs
All agents are running I validated
my database size is 550GB but the distributer database size is 230Gb
networks connectivity is also good
undistributed value also increases day to day
any idea about this issue

[janweealapar]

Great video! BTW, how to configure bidirectional transactional replication?

[chirayuzambare]

I have one of question. Which edition are you using in this demo ?

[deepikajoshi]

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

[karthikeshk]

Hi Sir,
Great Tutorial.

I'm getting below error in job monitor - history, please help

Unable to start execution of step 2 (reason: Error authenticating proxy LAPTOP-K4BQH98K\91889, system error: The user name or password is incorrect.

can you suggest, where to get process account name ? - this to configure security in snapshot agent

[maheshsaini]

Hello sir thank you for this wonderful video. i have some question here for replication you install all three server as stand alone sql. second one all three servers are domain joined server. third one is it mendatory to login all three servers with the same users. please reply it will clear all doubt

[srikanthg]

Please make a video on performance tuning

[ramukomera]

Dear RH, also make videos on PERFORMANCE TUNING....