Basic criteria requirement for replication

Question

Post reply

Basic criteria requirement for replication

mohan.bndr

SSCrazy

Points: 2360
More actions
March 6, 2016 at 10:48 pm

#325350

Hi All,
Can you please describe the exact basic criteria required to configure replication ( prerequisite).....That is what we require from user perspective. Please suggest. Thanks !!!

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

Which kind of replication? Merge? Transactional? Peer to peer? Snapshot? One way? Two way?

-- Gianluca Sartori

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

Tried the documentation?

https://msdn.microsoft.com/en-us/library/ms151198.aspx

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

mohan.bndr SSCrazy Points: 2360 More actions · Answer 3

spaghettidba (3/7/2016)
Which kind of replication? Merge? Transactional? Peer to peer? Snapshot? One way? Two way?

We have to configure Its Transaction replication.....tell the requirements to be check for user perspective. Thanks !!!

spaghettidba SSC Guru Points: 105732 More actions · Answer 4

This page (first Google hit for "sql server requirements for transactional replication") details all the requirements:

https://technet.microsoft.com/en-us/library/ms151254(v=sql.105).aspx

If you have more specific questions, we're here to help.

-- Gianluca Sartori