question

vivekchandra09 avatar image
vivekchandra09 asked

Need to install Replication on SQL Server 2008 R2

I need to install replication on SQL Server 2008 R2. SQL 2008 R2 is already installed. What should I do?
sql-server-2008-r2replicationsql-server-2008-r2-standard
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

I am attaching the discovery report for the instance.[link text][1] [1]: /storage/temp/3890-discovery-report.xlsx
0 Likes 0 ·

1 Answer

·
sjimmo avatar image
sjimmo answered
In order to install replication you need to know your environment, and define what your goals are. You also need to know and understand what the different types of replication are and how they work. Then start planning your installation. You will need to make decisions on whether or not to use a remote distributor or a local one. Validate what you are planning to replicate. Is there a primary key? Does it require a primary key to replicate? Once the legwork is done, replication itself is very easy to install. Replication is very diverse, and there are many a variety of ways of operating it. But out of the box works in most situations. Here is a link to help you get started: https://technet.microsoft.com/en-us/library/bb500348(v=sql.105).aspx as well as http://searchsqlserver.techtarget.com/tip/SQL-Server-database-replication-tutorial
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.