Solved

SQL SERVER 2008 Peer to Peer Replication

Posted on 2010-11-08
4
527 Views
Last Modified: 2012-05-10
I am trying to achieve a Peer-to-Peer Replication in SQL Server 2008 ā€“ Configure a two-node topology

We have a head office and a branch office. Currently applications installed in the branch office connect to the SQl server via a VPN. This solution is really slow and causes the applications to stall all the time.

Thus we decided to do a peer to peer replication in SQl server 2008 :

I followed the steps listed in this article :

http://www.databasejournal.com/features/mssql/article.php/3814591/Peer-to-Peer-Replication-in-SQL-Server-2008--Configure-a-two-node-topology.htm

My Questions :

1. Do we need SQl server 2008 EE on both ends to make this topology work?(There is a comment posted after the article which claims that you need SQL Server EE on both ends.)

2. When Setting up a publication do I need to include SPs, Views, functions as well in published articles or just including the tables are enough?
 
0
Comment
Question by:isaackhazi
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 4

Accepted Solution

by:
monicai earned 500 total points
ID: 34090043
1.  Replication may not be limited to Enterprise edition.  You can use Standard versions or Workgroup/express (as subscriber).  Here is the matrix of replication features avaialble for SQL Server 2008 http://msdn.microsoft.com/en-us/library/cc645993.aspx#Replication

2.  It depends on how often you change your SPs, views and functions and how dependent is your data with it.  If you don't expect these objects to change over time, it would be best to leave it out and apply it manually.
0
 
LVL 8

Author Comment

by:isaackhazi
ID: 34090097
Hi,

       thanks for clearing that out.

When I try to set "enable peer to peer subscriptions" to "true" I get the following error in a system sp.


P2P.png
0
 
LVL 10

Expert Comment

by:Ramesh Babu Vavilla
ID: 34092696
peer  to peer is not possible with your application. peer to peer is  a process where both the server acts as publisher and subscriber.better use merge replication for relability
0
 
LVL 8

Author Closing Comment

by:isaackhazi
ID: 34118136
Good
0

Featured Post

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE sā€¦

632 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question