1
vote
1answer
20 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
0answers
64 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
105 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
110 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 ...
0
votes
1answer
33 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 ...
0
votes
1answer
225 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 ...
0
votes
0answers
68 views

Merge replication web sync pull error

I have some problems with web synchronization for the Merge Replication. I repeated every step described here but I have always the same error: Security Error ....Unable to connect to the URL ...
0
votes
1answer
518 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 ...
1
vote
1answer
293 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 ...
1
vote
0answers
96 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
124 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 ...
2
votes
1answer
111 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
333 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 ...
1
vote
1answer
203 views

How to edit publication's generation_leveling_threshold configuration value

I dont know where I put this code: update sysmergepublications set [generation_leveling_threshold] = 0 I only need do it. But I need edited any funcion of agent.
1
vote
0answers
207 views

How to delete orphaned records from sysmergesubscriptions table?

I have some old orphaned records for old subscriptions that I want to delete from the sysmergesubscriptions table. Each time I delete unnecessary records, it show up again after it syncs with any ...
1
vote
2answers
2k views

How to properly clean Merge Replication Setup

What is the proper way to completely clean Merge Replication setup ? I have tried to delete the subscriptions, then delete the publication then "Disable Publishing & Distribution" & delete ...
5
votes
2answers
560 views

SQL Server Replication Alternative Software

We have used SQL Server Replication for a long time and had some issues with it that sometimes we needed to reinitialize subscriptions to fix some issues & other times we needed to destroy the ...
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 ...
1
vote
1answer
202 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 ...
4
votes
1answer
135 views

How to reinsert corrected rows from the conflict table?

I have a bidirectional merge replication. I had failure constraints because the primary key was just integer. I change the primary key to the old primary key + a location identifier.The problem is how ...
0
votes
1answer
123 views

Advise On SQL Server Data Replication

We have a huge enterprise system, with geographically seperated SQL servers. We have some requirements related with data replication between these servers. We have considered the Sync Framework ...
1
vote
1answer
199 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 ...
5
votes
3answers
1k views

What type of SQL Server Replication fits our scenario? Merge or Transactional?

Background In our current setup, we have a single SQL Server 2005 instance on our remotely hosted web server. We additionally have another (non-MSSQL) database which we use for our POS system, which ...
3
votes
1answer
100 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 ...
2
votes
1answer
321 views

SQL Merge Replication: Cannot resolve conflict

I have a SQL Merge Replication over HTTP (Replisapi.dll). I'm not very familiar with the internas of the replication conflict solving because it was always working so far. Now I have two conflicts in ...
1
vote
1answer
203 views

Minimising downtime implementing merge replication on live system

Background We have three Servers running SQL Server 2008 which all contain a Product database. These are currently kept in sync once per day by sending a copy of the MDF to the two Subscribing ...
1
vote
1answer
434 views

How to troubleshoot SQL Server Merge Replication Conflict?

I have SQL Server 2008 R2 Merge Replication setup. I have 2 publications for the same database with 20+ subscribers. The logic of our application prevents changing the same data from 2 subscribers ...
3
votes
1answer
192 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
2answers
1k views

Oneway sync of two SQL Servers via FTP

I need to replicate data from a ‘master’ SQL Server out to a number of replicas. Luckily the data only flows from the ‘master’ to the replicas. I need to replicate both schema and data. Data size ...
8
votes
1answer
3k views

Upgrade SQL Server 2005 to SQL Server 2012

I have a test environment set up with the following: Virtual Machine (Hyper-V) Windows Server 2008 R2 SP1(x64-bit) Windows SQL Server 2005 Developer Edition SP4 (x64-bit)(default instance name) 1 ...
2
votes
1answer
685 views

Merge replication SQL Server 2008 publisher with SQL Server 2012 subscriber

is this somehow possible to have SQL Server 2008 publisher with a SQL Server 2012 subscriber for merge replication?
1
vote
1answer
270 views

SQL Server 2005 merge replication failure

We have a customer who, when trying to sync a client (subscriber) to the server (publisher,) receives the following error: 2012-11-30 21:03:33.334 Percent Complete: 18 2012-11-30 21:03:33.334 Data ...
5
votes
2answers
214 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
321 views

Does The Stored Procedure sp_removedbreplication Remove Rowguids

In merge replication if I run sp_removedbreplication will that remove rowguids or not? Will it take into account the preserve_rowguidcol values in the sysmergearticles table?
1
vote
1answer
290 views

Locking And Blocking With Merge Replication

I am using merge replication in SQL 2012 with web sync. When I insert records into the top tables in my filter hierarchy it causes a lot of locking on the tables, including the merge replication ...
5
votes
1answer
440 views

The issue of sp_MScheckIsPubOfSub stored procedure

We have SQL Server 2008 R2 Merge replication set up. We have 20+ push subscriptions. Once in a while I get the following error message during the sync: Error messages: The merge process could not ...
1
vote
1answer
54 views

Merge Replicate, reinitialise with a different part of the data

I have a set of database with merge replicate configured between them. The publisher is an aggregate of three sets of data. Call them set 0, 1, and 2 There are subscribers that grab one set of the ...
1
vote
0answers
49 views

Merge Replication Finding Session Id

I am using merge replication with SQL 2012. I am writing a custom business logic handler, and would like to know if there is a way to get a session id? For instance if the custom business logic ...
0
votes
1answer
169 views

How to understand what Columns Have Changed in Merge Replication

I am using merge replication in SQL 2012. Some of my merge articles use column level tracking. I am trying to understand how to use the 'lineage', and 'colv1' fields in the MSmerge_contents table to ...
2
votes
3answers
1k views

Table with identity column in merge replication

I have a table in SQL Server 2005 and I have an IDENTITY(1,1) property set for an ID column. Records are inserted in a table at a local server as well as a remote server. I am using Merge ...
1
vote
1answer
200 views

How Can I Isolate A Merge Replication Timeout

I am using merge replication in SQL 2012 with web sync. When I create my subscription I am getting a timeout. The error message is not clear about cause of the timeout, but what I do know is if I ...
2
votes
1answer
174 views

How can I modify a trigger at subscribers SQL Server 2005?

I have a SQL Server 2005 publisher with SQL Server 2005 subscribers and one SQL Server 2000 subscriber running merge replication. Is there any way to modify triggers at a subscriber with the ...
2
votes
2answers
591 views

What is the Maximum Merge Articles in Merge Replication [duplicate]

Possible Duplicate: Hard limitation for merge replication article count? I am using merge replication in SQL 2012. I am looking here: Maximum Capacity Specifications for SQL Server (2012) ...
4
votes
1answer
108 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
367 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 ...
1
vote
1answer
357 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 ...
1
vote
1answer
216 views

Why Regenerate Snapshots For Merge Replication

I am in the process of implementing merge replication in SQL 2012 with web sync. I am wondering two things, Why is it suggested to regenerate the snapshots every 14 days by default? With web sync ...
1
vote
1answer
568 views

Merge replication - can't create snapshot – timeout

I have a SQL Server 2008 database, and I need a merge replication because I want to sync with mobile devices afterwards. So I created a replication but when it comes to start the snapshot agent, the ...
2
votes
0answers
60 views

How to Remove Articles Based on User

I am using merge replication on SQL 2012. I have a very large database with a large number of tables. The subscribers are using netbooks. I have a filtering scheme that controls which tables end up ...
3
votes
0answers
80 views

How Much Overhead Does Web Sync Add?

I am running merge replication in SQL2012 using web sync. Has anybody done any experiments to compare the performance of web sync to connecting to replication using a straight TCP/IP connection? ...