Configure Transactional Replication in SQL Server 2012 Step by Step [HD]

32 thoughts on “Configure Transactional Replication in SQL Server 2012 Step by Step [HD]”

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

• good video and clear instructions thenk

• ESILm

• Great, thank you very much for the detail video

• Can we set the dB name to be same for the publisher DB and the subscribed DB

• thank you very much.. this helping me so much

• I got this error: "A .NET Framework error occurred during execution of user-defined routine or aggregate "sp_scriptdropdelreconciliationproc_sqlclr":
  
  System.Data.SqlClient.SqlException: The locale identifier (LCID) 8192 is not supported by SQL Server.
  "

• It's good explanation

• How to use this concept?? On SQL Cluster HA configuration…

• Thank you so much sir.

• Nice video

• Hi Manzoor very good presentation.
  If i want to extend replication how can i do. I means. i have replication tableA last 2 month.
  now i want to replication to another tableB and tableC. How can Update?

• Full data is not replucate
  How to slove replication issue

• Excelent Work

• merge replication is possible in two different city through the agent on the behalf of static ip

• help me

• Excellent

• Sir, I have a question. If an organization have multiple branches and each branch have local server. But main central database server is placed an another place e.g Headoffice. So what is a solution to update all clients data to each other on each transaction and also update main central server. and central server also have two server one is live and one is for backup. Thanks in advance.

• Thank you

• Thanks nice tutorial

• Very good video and clear instructions.

• not bad. you should describe subscription briefly.

• Good primer video for Trans-Replication.  At the end I had to change the DB Owner to SA.  Thank you for your help — even two years later!

• Good Video. Two questions , how to create a network path and from where did you get the local account name for the process account. Thanks

• How many secondary servers we can add in logshipping??

• Hi Manzoor,
  Prodcution standard edition 2012 (publisher) and report server 2016 web edition(subscriber) is this environment eligible for replication? (snapshot and tran repl)

  Please suggest

• Hi,
  I was trying to setup replication. So i went ahead and configured my distributor and then carried on with my Publisher configuration. Once i finished up with the publisher i tried starting the snapshot and log reader agents.
  I get a red cross on my server in the monitoring screen and this is the eror message i get:
  Login failed for user 'NT ServiceSQLAgent$MSSQLSERVER3'.
  I know this is something related to the DB roles as db ownership but i am unable to solve this issue.
  Please help
  Thanks

• hey friend,

  At last it gives me this error how to solve it…

  An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) —————————— No active subscriptions were found. The publication must have active subscriptions in order to post a tracer token. (Microsoft SQL Server, Error: 21488)

• good one

• Hi Manzoor,

  Its really helped me a lot to understand and configure the transnational replication.
  Great work. thanks a lot man.

• Thank You !!
  Awesome Video !! Keep it up Dude !!

• Thank you very very much, this was a neat and easy to understand Tutorial.

Comments are closed.