Tagged Questions
0
votes
0answers
20 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 ...
0
votes
2answers
32 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 ...
1
vote
2answers
62 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 ...
0
votes
1answer
34 views
Merge subscription behaviour
I have a merge subscription with the ExchangeType parameter set to 1 (upload only).
Rows are transferred to the publisher as expected.
If I delete a row at the subscriber, the corresponding row at ...
4
votes
4answers
108 views
PK as ROWGUIDCOL or use a separate rowguid column?
There's a long-winded debate going on here so I'd like to hear other opinions.
I have many tables with uniqueidentifier clustered PK. Whether this is a good idea is out of scope here (and it's not ...
0
votes
1answer
90 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 ...
2
votes
2answers
28 views
Querying number of subscription to each publication
We have a production box that has about 60 publications on it. Some of these are used, and some seem to not be... What I need to do is create, or find, a script that will get the count of ...
2
votes
0answers
52 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 ...
4
votes
1answer
75 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
78 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 ...
0
votes
3answers
138 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 ...
5
votes
3answers
248 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 ...
2
votes
1answer
102 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
80 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 ...
0
votes
1answer
109 views
SQL Server merge replication across domains
I'm getting the following message when trying to set up merge replication on SQL Server 2008 R2:
The Merge Agent failed to locate the partitioned snapshot for this
subscription in the expected ...
7
votes
1answer
402 views
SQL Server distribution database log file grows uncontrollably after full database backup
We have a merge replication environment that is pushing to 8 subscribers. This is working fine. Our distribution database is setup in Simple recovery mode. We have a maintenance plan that will backup ...
0
votes
1answer
181 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
0answers
111 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
389 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
861 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 ...
1
vote
1answer
126 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 ...
7
votes
1answer
131 views
Estimated versus actual query plan with function calls
I have this query on SQL server, a merge replication query:
SELECT DISTINCT
b.tablenick,
b.rowguid,
c.generation,
sys.fn_MSgeneration_downloadonly
(
c.generation,
...
1
vote
0answers
55 views
How To Use Publication Without Precompiled Partitions
I am using SQL 2012 with merge replication. Our setup is quite complicated and thus it seems running the publication with precompiled partitions is not going to work.
The merge agent is slow to do ...
2
votes
0answers
49 views
How To Diagnose Slow sp_mssetupbelongs
I am using merge replication with SQL 2012.
When performing a clean sync using the merge agent I am getting a timeout on this stored procedure,
sp_mssetupbelongs
I am wondering what the best way to ...
2
votes
1answer
76 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 ...
2
votes
0answers
45 views
MSMerge_contents Table Populated After One Sync
I am running merge replication with SQL 2012.
When I first create my publication the MSMerge_contents table is populated with a large number of records with the colv1 being set to 0xFF.
When I run ...
0
votes
1answer
177 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
109 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 ...
1
vote
1answer
37 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 ...
0
votes
0answers
39 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
57 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
358 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
102 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
107 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 ...
1
vote
2answers
240 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)
...
3
votes
0answers
73 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, ...
6
votes
1answer
272 views
Deadlock on Merge replication
I'm having a really confusing problem on the msmerge_contents table on some
of my merge replication databases. It seems I'm receiving a dead lock on the exact
same row on the same index on the table ...
1
vote
2answers
48 views
Does sp_addtabletocontents Use Precomputed Partitions
I am using merge replication in SQL 2012.
When I bulk insert rows into a table, and run this stored procedure to add references into the merge tracking table,
sp_addtabletocontents
Is that missing ...
3
votes
0answers
159 views
SQL Server 2008 R2 - Merge Replication - Can the Distribution Database size cause replication problems?
Setup:
We have a SQL Server 2008 R2 instance running on a central server.
The server is a merge-replication publisher.
We have 'N' subsribers running SQL Server 2008 Express. 'N' can grow to any ...
2
votes
0answers
56 views
Merge Replication Optimization
I am running Merge Replication on Microsoft SQL Server 2012 through web sync.
Is there a way to recognize when regenerating a new snapshot and applying it would be more efficient than running a ...
2
votes
0answers
136 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 ...
8
votes
2answers
221 views
Hard limitation for merge replication article count?
A bit of background. We developed an app that uses merge replication. Right now, we are currently publishing about 212 articles, and everything is fine, as it appears to fall into the 256 article ...
0
votes
0answers
80 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 ...
2
votes
1answer
38 views
What else does sp_addmergefilter do
I am running the following stored procedure to add a merge replication join filter,
sp_addmergefilter
What else does that stored procedure do behind the scenes?
I am calling that stored procedure ...
1
vote
1answer
124 views
SQL Server Merge Replication, Agent Batch Size
Is there anyway to increase the merge agent batch size after the publication is created?
I know DownloadGenerationsPerBatch flag when creating a new Publication, however what I'm looking for is a way ...
2
votes
1answer
158 views
Why would “Drop Database” fail on local SQL Server 2005 Express instance?
I am trying to run the below code. It works for me but not for at least some of my users it doesn't work. It doesn't seem to error just no actually remove the DB's.
string sqlConnectionString=@"Data ...
1
vote
1answer
120 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
360 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 ...
1
vote
0answers
51 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 ...
0
votes
0answers
182 views
How To Speed up Merge Replication
I am running SQL2012 merge replication on a netbook using SQL Express as a subscriber. The netbook has 1GB of RAM.
The replication process works quite well, but it is when it comes to applying the ...
