-
2 VotesReminder - please indicate if a reply has answered your question.
How do I indicate a post answered my question? If a post has answered your original question, please indicate this by clicking on the "Mark as Answer" button ...Sticky | 4 Replies | 53481 Views | Created by Greg Y - Thursday, December 7, 2006 8:22 PM | Last reply by Harry SQL DBA - Saturday, February 19, 2011 5:43 AM
-
2 Votes
snapshot agent showing red mark in replication monitor!!!(Merge replication)
few days before snapshot agent showing red mark in replication monitor without any changes... synchronizing from publisher to subscribe working fine... and ...Answered | 9 Replies | 2703 Views | Created by Baraiya Kirit - Saturday, December 20, 2014 7:26 AM | Last reply by Vlad Maryland - Friday, December 27, 2019 7:37 PM -
2 Votes
data is not replicating from publisher to subscriber.
I configured transactional replication. However, data is not replicating from publisher to subscriber. I have attached screenshots of errors. Could you please ...Proposed | 6 Replies | 759 Views | Created by juniorkiran - Tuesday, December 3, 2019 2:48 PM | Last reply by juniorkiran - Friday, December 27, 2019 11:15 AM -
0 Votes
replicate high volume bulk inserts
30 minutes). I experimented to change some settings in the distribution agent (BcpBatchSize, CommitBatchSize, CommitBatchThreshold), but this doesn’t really change ...Unanswered | 4 Replies | 419 Views | Created by Stephan Orban - Thursday, December 19, 2019 3:05 PM | Last reply by Tom Phillips - Thursday, December 26, 2019 5:43 PM -
1 Votes
Subscriber node down in transactional replication
1) I have 2 node which node 1 is publisher and distributor in same server and subscriber in node 2. In case publisher is down for few hours and i need to bring up the subscriber for read and ...Answered | 2 Replies | 186 Views | Created by Mario2286 - Thursday, December 26, 2019 5:03 AM | Last reply by Tom Phillips - Thursday, December 26, 2019 1:12 PM -
0 Votes
Replication- Article Property
We have ServerA , TableA contains 10 columns ( consider Publication) & ServerB, TableB contains 15columns ( consider ...Proposed | 2 Replies | 330 Views | Created by KIRUBAKARAN J A - Sunday, December 22, 2019 3:56 AM | Last reply by Cathy Ji - Tuesday, December 24, 2019 10:15 AM -
0 Votes
SQl server Transaction replication -publisher shrink Transaction log
Hi I am having Transaction replication 2008 to 2014. Now publisher side Trasaction log grown up to 100 GB and need to clear. I have noted that T log backup was failed ...Proposed | 1 Replies | 174 Views | Created by ashwan - Monday, December 23, 2019 1:22 AM | Last reply by Cathy Ji - Tuesday, December 24, 2019 3:26 AM -
0 Votes
Invalid Object Name in p2p Replication in sql 2016
Hi Team, We modified data in user_city table at publisher. This is Peer-Peer replication in SQL Server 2016 after that we are getting this error ...Proposed | 2 Replies | 311 Views | Created by VijayKSQL - Friday, December 20, 2019 12:08 AM | Last reply by Cathy Ji - Monday, December 23, 2019 4:41 AM -
0 Votes
EMERGENCY - Enabling merge replication results in “DML statement cannot…” error
Having to set up Merge replication so that we can have SQL server in Europe and North America to reduce latency between our application servers and SQL. After ...Unanswered | 2 Replies | 324 Views | Created by JOGARA - Friday, December 20, 2019 2:57 AM | Last reply by Dawn Yang - Monday, December 23, 2019 2:17 AM -
0 Votes
cannot insert value -Violation of PRIMARY KEY constraint 'PK_urls'.
using prod db backup file , restored a database to Dev. this Prod db is in replication (subscriberDB). while ...Proposed | 3 Replies | 379 Views | Created by KIRUBAKARAN J A - Thursday, December 19, 2019 1:49 PM | Last reply by Cathy Ji - Friday, December 20, 2019 10:10 AM -
0 Votes
duplicate key row in object 'dbo.MSsubscription_articles'
0 rollback tran 2019-12-14 20:45:36.696 Category:NULL Source: Microsoft SQL Server Native Client 11.0 Number: ...Unanswered | 3 Replies | 851 Views | Created by VijayKSQL - Sunday, December 15, 2019 5:16 AM | Last reply by Cris Zhan - Friday, December 20, 2019 7:14 AM -
0 Votes
Merge Replication not deleting unmatched filter rows from Subscriber Database
I have applied filters on articles in SQL Merge Replication and syncing the data using MergeSynchronizationAgent via Web Synchronization. The data is syncing as per the applied filters from ...Proposed | 11 Replies | 882 Views | Created by M0Bilal - Monday, December 9, 2019 7:22 AM | Last reply by M0Bilal - Thursday, December 19, 2019 7:56 AM -
1 Votes
Getting error adding new subscribers in Snapshot Agent.
Migrated from SQL 2012 to SQL 2016. Now getting error adding new subscribers in Snapshot Agent. Error Message One ...Unanswered | 1 Replies | 395 Views | Created by juniorkiran - Wednesday, December 18, 2019 8:18 AM | Last reply by Amelia Gu - Thursday, December 19, 2019 6:01 AM -
0 Votes
SQL Server 2017 Replication Setup on Linux Server
Hi I have installed SQL Server 2017 on Linux Ubuntu 18.04 LTS. But I am unable to configure replication , please advise how can we install and configure ...Unanswered | 3 Replies | 432 Views | Created by WFX - Monday, December 16, 2019 12:02 PM | Last reply by Amelia Gu - Tuesday, December 17, 2019 2:46 AM -
0 Votes
how to get notification email or other means when replication is down?
hi, Sir and madam, i hit critical issues . finally i found out the reason is sql server 2014 peer to peer is down due to some reasons to fix ...Proposed | 5 Replies | 619 Views | Created by delaynomore - Thursday, December 12, 2019 3:19 AM | Last reply by Cathy Ji - Monday, December 16, 2019 7:28 AM -
0 Votes
Peer-Peer Replication
Hi Team, Getting below issue on Publisher in SQL 2016 Peer-Peer replication. But Subscriber is working fine: Cannot insert duplicate key row ...Unanswered | 2 Replies | 1335 Views | Created by VijayKSQL - Thursday, December 12, 2019 10:26 PM | Last reply by VijayKSQL - Saturday, December 14, 2019 8:59 PM -
0 Votes
Check 'Copy non-clustered indexes' replication article property using T-SQL
I need to check the property of this setting at the article level across my full transactional replication environment (several servers, dozens of publications, hundreds of ...Unanswered | 2 Replies | 739 Views | Created by KevinBHill - Friday, December 13, 2019 2:52 PM | Last reply by KevinBHill - Friday, December 13, 2019 9:55 PM -
0 Votes
SQL Server Replication Configuration- Stuck at Replication Administrative Password step.
Hi everyone, I have been struggling for the past one week to setup the replication in our environment and has been stuck on Administrative Password issue when ...Unanswered | 2 Replies | 676 Views | Created by Shaddy_1 - Thursday, December 12, 2019 6:46 PM | Last reply by Shaddy_1 - Friday, December 13, 2019 4:16 PM -
0 Votes
Switching properties without needing to reinitialize?
Greetings. We've got transactional replication setup between a 3 TB database and several reporting servers. For very long winded reasons we want to remove large amounts of data from ...Unanswered | 2 Replies | 591 Views | Created by ChrisRDBA - Thursday, December 12, 2019 8:50 PM | Last reply by ChrisRDBA - Thursday, December 12, 2019 10:44 PM -
0 Votes
issue with Peer-Peer Replaction in SQL Server 2016
Hi Team, We have configured Peer-Peer Replication and everything is working fine but getting below issue. Inorder to fix this issue , assigned Sysadmin role to ...Answered | 1 Replies | 631 Views | Created by VijayKSQL - Thursday, December 12, 2019 12:19 AM | Last reply by Dedmon Dai - Thursday, December 12, 2019 1:49 AM -
0 Votes
How to Handle Changes in PUBLISHER
We are running transactional replication on a application DB with approx 6000 tables. We are planning to upgrade the application and in doing so, a number of tables are ...Proposed | 1 Replies | 597 Views | Created by ARPRINCE - Wednesday, December 11, 2019 5:31 PM | Last reply by Hilary Cotter - Wednesday, December 11, 2019 6:07 PM - Items 1 to 20 of 11995 Next ›
