How to Setup Peer To Peer Replication in SQL Server 2016 - SQL Server 2016 DBA Tutorial

[@bharathpr]

hEllo, how to create a process account for a non domain stand alone instance

[@louis745]

About your replication account (at 4:57 in the video) can you tell me more about the account you use.

[@cbvidals]

Server NT account or AD

[@Ioszono]

Hi, best explication.. Please, one question, es posible generate replciacion en same server whit two database for diferents aplicatiosn but equal data? (with peer to peer)

[@TechBrothersIT]

Not recommend but it’s possible, if it’s on the same server all dev team needs to do is put dbname.schema.objectname to access the data, not sure why replication is needed on the same server unless database architecture is different in prod and keeps you from following promotion to prod process?

[@sumitdj4u]

thanks for video can we do replication only for certain period like every week only for last 2 weeks data to be replicate (like from prod to dev )

[@Mubashir2771]

Hello Techbrothers I need to ask you told in this video first, that if changes been made in Database after synch we will need backup taken again and should be restored in other nodes.What does that mean? I mean you have made changes in Database in last and thats replicated in other nodes i.e change in the first and last node but you didnt backup again.

[@TechBrothersIT]

That’s initial setup - once you are done setting up, all changes will be replicated. Initial setup requires in synch databases, otherwise it will not let you setup and ask you to take backup again and restore on all target nodes.

[@SanJay-qt5tj]

awsome thanks for simple explanation video

I know this is an old video, but I'm getting a PK issue every time I try to insert data from one of the other 2 peers. If I insert, update, or delete on the Master's end everything's fine. But when I try to do any DML on the others it just breaks, and I'm not sure what exactly am I missing as far as configurations goes. PD: Thanks for the vid!

[@xiaocheng1937]

sounds like a primary key violation to me.

[@louis745]

And your server is in a domain?

[@TechBrothersIT]

Yes, it is.

[@np-wl7hf]

clear guide) Thanks!

[@Ahmad.Yousefipour]

Thankssssss