Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [merge-replication]

29 questions
6
votes
2 answers

Data from a table in 1 DB needed for filter in different DB

I have a Win Form, Data Entry, application that uses 4 seperate Data Bases. This is an occasionally connected app that uses Merge Replication (SQL 2005) to stay in Sync. This is working just fine. The next hurdle I am trying to tackle is adding…
Refracted Paladin
  • 345
  • 7
  • 19
4
votes
1 answer

Limitations in SQL Server merge replication - Publication to number of subs

I'm looking for a couple different things here. From what I can find, Workgroup edition supports up to 25 subscribers per publication. Does anyone know the limit, if there is one, to the number of subs per pub in both Enterprise and Standard…
DanBig
  • 11,393
  • 1
  • 28
  • 53
4
votes
2 answers

Will this force a reinitialize in Merge Replication Topology?

I need to add a couple of columns to a table that is a part of a replication set. It is not a constraint coulumn or a part of any article filters and it allows NULL. I have a pretty good idea that I can run this --> ALTER TABLE tblPlanDomain ADD…
Refracted Paladin
  • 345
  • 7
  • 19
3
votes
1 answer

Alter Stored Procedure in SQL Replication

How do I, properly, ALTER a StoredProcedure in a SQL 2005 Merge Replication? I just need to add a Column. I already successfully added it to the Table and I now need to add it to a SP. I did so but now it will not synchronize with the following…
Refracted Paladin
  • 345
  • 7
  • 19
3
votes
1 answer

Replication sync failing; Publisher out of Identity ranges

I have Merge Replication set up with a SQL 2005 Publisher/Distributor and roughly 100 SQL 2005 Express Subscribers. Everything was working fine for months and now all of a sudden everyone is getting the below errors. I have been Googling around but…
Refracted Paladin
  • 345
  • 7
  • 19
2
votes
0 answers

SQL Replication cannot access file

When setting up a subscriber it fails on the first sync with the message The process could not read file due to OS error 2 I have tried setting the security rights for the directory to full control for the user credential that runs the…
Cornelius
  • 131
  • 1
  • 6
2
votes
1 answer

SQL Server 2008 Chaining Merge Replication

Is there a way to have multiple "tiers" for a merge replication in SQL Server 2008. For example I have SiteA with SQL Server 2008 that has a publication setup on TestDB. SiteB, also with SQL Server 2008 is subscribed to the SiteA publication for…
ctrlalt313373
  • 211
  • 2
  • 7
2
votes
1 answer

Problems with merge replication

We are developing a multi-user desktop application with users located in different countries. The platform is - .net 3.5, SQL Server 2008, WinForms. Now, my client has used the help of a DBA who has implemented merge replication. To facilitate…
user57744
2
votes
1 answer

SQL Merge Replication - Filter Sets

I have a "working" Replication Set in SQL 2005 that we use in house to our users at remote branches on SQL Express 2005. I want to apply a filter to our biggest Set to help minimize the bandwidth impact. What I am asking is what considerations do…
Refracted Paladin
  • 345
  • 7
  • 19
2
votes
2 answers

Merge Partitions Server 2003

I just installed new 500gig drives to replace 160gig drives in my RAID server running Windows 2003 Server. I was wondering if someone could recommend a utility program that would help me recover all the new space on the new drives and also to merge…
user32762
1
vote
2 answers

Is Peer-to-Peer replication a replacement for a merge-replication?

please help me in evaluating new possibilities with MS SQL Server 2008. For the last 3 years I have had an MS SQL 2000 Server Merge Replication with a Publisher and two Subscribers on duty, the backup of the database on one instance is as big as 19…
Ice
  • 404
  • 1
  • 7
  • 16
1
vote
1 answer

Error when using sp_addscriptexec

I have tried to run the following command on my server that is using sql 2008 merge replication sp_addscriptexec MyPub, '\\my-server\MSSQL\updateTablePermissions.sql', 1 and I get the following error message Msg 21330, Level 16, State 1, Procedure…
PlTaylor
  • 1,067
  • 7
  • 8
1
vote
1 answer

Merge Replication Publishing Subscriber Scenario

I have a merge publishing subscriber topology of SQL 2008 -> SQL 2000 -> MS Access 2003. In one database at the SQL 2008 level, I have an updateable publication (called catalog) that is unfiltered, subscribed to by the SQL 2000 server, and then…
Brian Dunzweiler
  • 23
  • 6
1
vote
3 answers

SQL INSERT INTO vs SELECT INTO vs BCP in a Replication Topology(Stage Environment)

I would like to add the information from my Production DB to my Stage DB. I have a BAK of the Production DB and could just restore from that on Stage but I am concerned of the impact Merge Replication will have on that. Let me explain further; I…
Refracted Paladin
  • 345
  • 7
  • 19
1
vote
1 answer

Merge Publication Data Partition Snapshot generation

I have a merge publication in SQL 2008 R2 with data partitions and I am wondering when I should generate the snapshots for the data partitions. I get an error sometimes when bringing a new subscribe online related to the partition snapshot being…
ctrlalt313373
  • 211
  • 2
  • 7
1
2