A type of replication in SQL Server in which Publishers and Subscribers can work autonomously and later reconnect, synchronize, and merge data changes to achieve convergence among all nodes in the topology. Merge replication is typically used in server-to-client environments.

learn more… | top users | synonyms

1
vote
1answer
220 views

SQL Server replication conflicts after migration from 2000 to 2008

I got a suggestion over at Stackoverflow to post here....greatful for any and all help. Please bear with me I think this might take a while to explain. For many years now my company has hosted a ...
1
vote
1answer
146 views

List of Expired Merge Subscribers

I have a setup of merge replication. Sometimes, subscribers will not be able to sync within the retention period set in the publication. How can I get a list of expired subscribers to a merge ...
0
votes
1answer
19 views

Automating SQL Server Merge Replication Processes [closed]

Hi all is there anyway I can automate the entire process of the Merge Replication?
1
vote
1answer
104 views

How to tell what user has synced

I have set up merge replication web sync to sync a publication from a SQL Server 2012 database. I am trying to make some parameterised filters using SUSER_SNAME() or HOST_NAME(). When I do a sync is ...
1
vote
1answer
415 views

How to user the Tablediff Utility with Replication Filters

I am using merge replication in SQL 2012. I am trying out the TableDiff utility to show non convergence. I see a problem with this approach though. This is because I am using parameterised filters to ...
0
votes
1answer
24 views

The message “Running the Merge Agent process would exceed the maximum number of processes allowed” appears, but it doesn't seem likely

The full text of the message is "Running the Merge Agent process at this time would exceed the maximum number of processes allowed by this publication. The process will run when resources become ...
0
votes
3answers
853 views

Merge Replication identity field issues

One of our clients is using our software with merge replication of a database on a SQL Server 2008 R2 machine. There are two production environments in separate geographical locations only one of ...
2
votes
0answers
24 views

Replication stopped working, no errors

I have a TOP server (SQL Server 2012) with a merge replication to around 4 other servers. When I subscribe to the publication, everything is downloaded fine to the subscriber. The insert of one of ...
0
votes
1answer
25 views

SQL Server 2012 Replication, how to ignore action with specific trigger?

SQL Server 2012. Database is in merge replication, no conflicts presented. Current example is simply for understanding, but real schema is very huge to describe. Schema and trigger at SQLFiddle for ...
0
votes
0answers
21 views

Database Read Only after Merge Replication

Win Server 2012, SQL Server 2012 Std. I have a previously accessible database with which I'm testing merge replication and after I publish the DB, my application is saying the DB does not have write ...
1
vote
1answer
240 views

Syncronize mysql databases between local and hosted servers automatically

We have many website with Development , Staging and Production Server. we have many developers for many projects, we need a solution to synchronize the database with developer database with staging ...
2
votes
2answers
1k views

SQL Server Replication: “ALTER TABLE ALTER COLUMN” is not propagated to subscribers

We are running SQL Server 2008 R2 SP1 as publisher & distributor, and SQL Server 2005 SP3 as subscriber. The replication of schema changes is activated, and the replication has been running for ...
0
votes
1answer
15 views

I couldn't see Conflict tables in replication monitor SQL Server 2008 R2 in Merge Replication

I work with merge replication in SQL Server 2008 R2. In the replication monitor I can't see conflict table, I must to see conflict tables in "MSmerge_conflicts_info", please help me. How to see ...
0
votes
1answer
271 views

SQL Server replication - set PollingInterval in sp_addmergepushsubscription_agent

I am trying to create replication subscriptions to and SQL Server 2008 R2 via a script. There are 3 subscribers so this script creates the subscriptions by calling sp_addmergesubscription and then ...
5
votes
2answers
286 views

Why Do Replication Deletes Require sysadmin Access

I am running merge replication with SQL 2012. There seems to be a nasty consequence of the delete triggers added for replication in SQL 2012. Inside the delete triggers are this, select @xe_message ...
0
votes
1answer
643 views

Merge reports 'You must rerun snapshot because current snapshot files are obsolete', gets caught in Death Loop

We have a very large Merge publication for a data warehouse with some large (.bcp files on the order of 20GB) fact tables that is causing us tremendous trouble. Specifically, we created a publication ...
0
votes
1answer
15 views

MSSQL 2000 replication, incrementing an integer column on a single row using an update statement

I have 2 web servers, both of which connect to separate mssql 2000 database servers, these two servers use merge replication in order to collate tracking data. Now each web server runs an update ...
1
vote
1answer
54 views

Replication consistently fails to bring new rows to subscriber

Short description of the problem: Initial synchronisation to the subscriber works fine. Subsequent synchronisations fail to download new rows. Re-initialising the subscription "fixes" the issue and ...
1
vote
0answers
71 views

The replication Merge Agent failed to propagate a Publisher schema change to the Subscriber

We are running 2 Microsoft SQL Servers - publisher (2008R2) / subscriber (2008 Express) with merge replication. I tried to make some schema changes via Transact-SQL and partly failed. So tried to ...
0
votes
1answer
37 views

Merge Replication API with SQL Server 2012 / 2014

We are using SQL Server 2008 with merge replication. Our business application uses the rmo api, which we have installed with SQL Server Feature Pack 2008 SP3 and there the package sql_rmo.msi. Now we ...
0
votes
0answers
50 views

Merge Replication — Reinitialize Without Recreation

I have a publication with ~10 subscriptions configured as clients. They all have a partition of that data using row filters. Earlier this week I received this error on two of the subscriptions: ...
0
votes
0answers
13 views

How to back out of mass update in SQL Replication [duplicate]

We have a database which is set up in Merge Replication. We accidentally updated hundreds of thousands of records in a large published table on the publisher database. We did is something like ...
2
votes
1answer
67 views

How to back out of mass update in SQL Replication

We have a database which is set up in Merge Replication. We accidentally updated hundreds of thousands of records in a large published table on the publisher database. We did something like this: ...
1
vote
1answer
28 views

Restarting a Publisher involved in Merge replication

Our hosting provider would like restart the SQL Server that a publisher in a merge replication topology. I'm not able to clearly understand best practice for doing this from the Microsoft docs. Our ...
0
votes
1answer
38 views

Merge Replication - Merge initial data contained on subscriber

I have two identically structured databases on two separate servers. Both have different data within them. I have set one of them up with merge replication as a publisher and I want the other to be ...
0
votes
1answer
73 views

SQL Server Merge Replication Change Partition Definition

I am using Merge Replication on a few SQL Server 2008 R2 servers. There is one server, and the rest are clients. I have each of the clients on a different partition using row filters with the ...
3
votes
1answer
101 views

How can we achive the replica of databases for SQL Server?

I have been working in VB6 to VB.NET migration project.In VB6 project they have individual databases (access db .mdb) for every user now we made that to centralized database using SQL Server. In the ...
0
votes
1answer
36 views

Merge replication parameterised filters

We are looking at using merge replication to maintain a 2-way data flow between a central SQL Server 2012 Standard database and, eventually, 100's of international satellite SQL Express 2012 ...
1
vote
1answer
323 views

Snapshot agent stuck at 48%

We are having to redo a publication/subscription and while running the snapshot agent it stalls at 48% with the message "The process is running and is waiting on a response from the server." ...
0
votes
0answers
71 views

SQL Server 2012 Replication Initialisation Fails — Table keeps being dropped

I have two servers - one located in Australia (Distributor / Publisher), and a second in the UK (Subscriber) both on Amazon's cloud. I have attempted to configure replication as both pull and push ...
1
vote
4answers
111 views

Backup from Server1 and restore it to Server2?

IF we have two Servers installed with SQL Server 2008 instances, Server1 has three drives C, D and E with 100, 500 and 500 GB respectively and Server2 has three drives C, D and E with 100, 300 and ...
2
votes
1answer
125 views

SQL Server Merge Replication Dummy Update issue

We have SQL Server 2005 SP4, using merge replication. We started getting this error when the subscribers try to replicate (not all of them but most): The process could not deliver dummy update ...
2
votes
1answer
394 views

How does merge replication work with SQL Server CE

I have been trying out merge replication with SQL Server databases, and was just wondering how merge replication works on SQL Server CE? For instance merge replication with SQL Server databases ...
3
votes
0answers
150 views

merge replication too big

I have multiple handhelds which sync their data via merge replication. from time to time, new core data is imported on the server-database. for some reasons I keep the old data in the databse and set ...
1
vote
2answers
118 views

For merge replication, do I need to schedule index maintenance on all sites or just publisher?

I have a very fragmented database that uses merge replication with remote sites. Do I need to schedule index maintenance (reorganize / rebuild) for all sites? Or just on publisher copy?
0
votes
0answers
40 views

Subscription uploading is not happening every time

I have two SQL Servers (2008 R2), and merge replication between them, one being the publisher and the other subscriber. I noticed that downloads are happening every minute, but uploads are happening ...
1
vote
1answer
415 views

Mysterious merge replication problems creating a subscription

We have a merge publication which had been mostly working OK for a long time (years). Recently an article was added, we were informed the snapshot was out of date, so we regenerated it. Then we got ...
6
votes
1answer
1k views

Replicated Database Log File Maintenance

I have a database on the publisher that is involved in replication (publication configured for merge and transaction). Trying to regain control of the log file for this particular database (VLF count, ...
1
vote
0answers
111 views

Row not being deleted from the publication when it's deleted in a subscription

We've merge replication configured in our environment(1 Publisher, 3 Subscribers) and We know by default merge replication is bi-directional. Its working fine in case of inserts i.e, if a row is ...
0
votes
0answers
164 views

SQL Server Merge Replication Stuck, lots of conflicts and genstatus = 4 (interrupted) [closed]

Merge replication is the gift that keeps on giving as far as throwing new things at us, and the latest is a subscription that had been behaving for quite sometime suddenly slowing to a crawl. This ...
1
vote
2answers
211 views

Install SP 3 on SQL Server 2008, where merge replication is running

I have a SQL Server 2008 and I should install Service Pack 3 for it. On my server there are several databases replicated, and mobile devices sync data via merge replication. Can problems occur, if I ...
3
votes
1answer
209 views

How to replicate from SQL Server 2000 to SQL Server 2008 R2?

I have SQL Server 2000 as publisher and SQL Server 20008 R2 as subscriber. I want to replicate data from SQL Server 2000 to SQL Server 2008 R2 on a different machine. Primary key fields are not ...
2
votes
1answer
122 views

Merge replication issue : conflicts with new data

I set up merge replication with SQL Server 2008, I am having issues when creating new data on clients and trying to synchronize with the remote server. Pulling data from the server works fine. But ...
1
vote
0answers
397 views

Merge Replication Update Statement Timeout

I work for a company that provides web based data collection. Currently we have a SQL Server 2012 server as the publisher for 2 subscribers (planning on expanding up to 5+ subscribers), both SQL 2012 ...
0
votes
2answers
274 views

“an agent job has not been created for this subscription”

I have set up merge replication with a publisher on my SQL Server 2008 R2 box with the distributor on this box too; in Express I have created a subscriber but the subscriber won't run because of the ...
2
votes
1answer
389 views

How to Rename Table or Field With Merge Replication

I am using merge replication with SQL 2012. I am trying to rename a published table, and rename a published field. These operations are not permitted in merge replication. However I can think of an ...
0
votes
2answers
430 views

Merge Replication Subquery Filters

I am using merge replication with SQL 2012. I have a number of articles in my publication and will have to come up with quite an elaborate set of filters. If I add a filter on my article it can ...
4
votes
1answer
113 views

Multiple Merge Replications on same SQL Server Database Conflicts

I have 2 separate merge replications on the same database on a server, one named 'POC' with a single subscriber running continuously, and another named 'Clubs' with ~50 subscribers. As of recently, ...
2
votes
1answer
152 views

Import issue with Replication

When I import some data from excel file to a table that is part of a merge replication, the data is imported successfully to the table, but those new records are not synced to subscribers that belong ...
3
votes
0answers
158 views

How to properly troubleshoot Merge Replication False Conflicts

We have SQL Server 2008 R2 Merge Replication setup. Lately I started getting conflicts for some tables, and when I check the conflict viewer, I can see that the winner & the loser column values ...