-
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 | 51754 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
-
0 Votes
Replication: There is this merge replication which often shows genstatus with value 4
Replication: There is this merge replication which often shows genstatus with value 4. How to address it and minimize reoccurrence ? -
0 Votes
Distribution Agent Fails - Row Not Found at Subscriber
Hello. I started getting the following issue on my Transactional Replication with a remote Distributor: Distribution Agent fails with the message ...Answered | 2 Replies | 116 Views | Created by BogdanU - Thursday, August 22, 2019 2:37 PM | Last reply by BogdanU - Friday, August 23, 2019 2:35 PM -
0 Votes
Log Shipping Copy Job failed and tried to copy the transaction log which are 3 days old.
HI All , We have the Log shipping configured between the 2 instances and sometimes we get the issue or alert for copy job failed. after check the error logs ...Unanswered | 3 Replies | 147 Views | Created by Mukesh3388 - Thursday, August 22, 2019 1:46 PM | Last reply by Cathy Ji - Friday, August 23, 2019 7:42 AM -
0 Votes
Transactional Replication in SQL 2014
Recently we configured Transactional Replicaiton in SQL Server 2014 ENT. Both publisher and subscriber are on SQL Server 2014 ENT. it was working fine. But now ...Unanswered | 4 Replies | 194 Views | Created by VijayKSQL - Wednesday, August 21, 2019 5:23 AM | Last reply by VijayKSQL - Thursday, August 22, 2019 5:58 PM -
0 Votes
can a db that is already the target of trans replication also be the target of custom made etl?
hi we run 2017 std. Due to a lack of pk's on some publisher tables and 3rd party involvement, we may need to roll our own "replication" to a target db via ...Unanswered | 4 Replies | 169 Views | Created by db042190 - Wednesday, August 21, 2019 5:07 PM | Last reply by db042190 - Thursday, August 22, 2019 2:49 PM -
0 Votes
does merge replication physically add the row guid to the publisher side?
...if yes, isnt this a problem if the publisher side is a 3rd party product that perhaps has select *'s in it? we run 2017 std.Proposed | 3 Replies | 348 Views | Created by db042190 - Wednesday, August 21, 2019 5:00 PM | Last reply by db042190 - Thursday, August 22, 2019 2:33 PM -
0 Votes
can merge replication target a db already targeted by transaction replication
Hi we run 2017 standard. We are absent pk's on some of our tables that we want replicated to the same db where we already tran replicate many tables that do ...Answered | 1 Replies | 100 Views | Created by db042190 - Wednesday, August 21, 2019 4:58 PM | Last reply by Dedmon Dai - Thursday, August 22, 2019 7:25 AM -
0 Votes
Replication doesnt copy check and default constraints
Hi, i'm trying to create a transactional replication from DB A to DB B. Definition of A and B are the same, and i want to keep the B database with all the indexes, constraints, ...Answered | 2 Replies | 770 Views | Created by nemecek.jano - Wednesday, October 5, 2016 8:35 AM | Last reply by Ronzo3 - Tuesday, August 20, 2019 6:45 PM -
0 Votes
Snapshot Agent Times Out At SP_MSACTIVATE_AUTO_SUB
Hello. I have a Transactional Replication with a remote Distributor, on a DB that I was previously publishing, then removed the PUB and SUB (because I switched to a Remote ...Answered | 5 Replies | 266 Views | Created by BogdanU - Friday, August 9, 2019 9:22 AM | Last reply by BogdanU - Tuesday, August 20, 2019 3:07 PM -
2 Votes
Change Tracking Performance
146316152 ; The difference in the execution plan is the first one does an index seek on syscommittab using some scaler operator in the predicate where the second FASTER ...Unanswered | 4 Replies | 10521 Views | Created by J Reitz - Tuesday, June 29, 2010 11:15 AM | Last reply by Hilary Cotter - Tuesday, August 20, 2019 1:38 PM -
0 Votes
querying a database that has replication subscriber tables
Hi we run 2017 standard. we are wondering if queries run against replication subscriber tables can interfere (ie block) with the replication process. and if the ...Answered | 7 Replies | 308 Views | Created by db042190 - Thursday, August 15, 2019 12:27 PM | Last reply by Hilary Cotter - Monday, August 19, 2019 7:46 PM -
0 Votes
Replication issue on xml data in varchar(max) data type
I set up transactional replication and have an issues on xml data which is in varchar(max) data type. Recently I found some of the xml format got malformed on subscriber but not on ...Proposed | 4 Replies | 343 Views | Created by Prema Sambandam - Thursday, August 8, 2019 6:27 PM | Last reply by Hilary Cotter - Monday, August 19, 2019 3:06 PM -
0 Votes
Logical Records in Merge Replication
Good Day All, We're currently running SQL Server 2008 R2 in a merge replication topology. Publisher and distributor are on same ...Unanswered | 1 Replies | 116 Views | Created by 2012S4 - Sunday, August 18, 2019 3:24 PM | Last reply by Hilary Cotter - Sunday, August 18, 2019 5:17 PM -
0 Votes
what if i want replication but dont have a pk
Hi I have an incident history table that doesn't have a primary key. It is provided by a 3rd party so I don't have much of a choice there. it has a clustered index on the incident ...Answered | 5 Replies | 252 Views | Created by db042190 - Thursday, August 15, 2019 7:33 PM | Last reply by db042190 - Friday, August 16, 2019 12:36 PM -
0 Votes
SQL Server 2008R2, replicating from on-prem, to SQL Server 2008R2 VM in Azure
I have been tasked with migrating a database, size being up to 15Gb, from a SQL Server 2008 database in a 3rd party cloud VM, to SQL Azure. On go-live day, when we switch from the old host, the Azure, ...Unanswered | 1 Replies | 299 Views | Created by CraigInBrisbane - Thursday, August 8, 2019 11:24 PM | Last reply by Dedmon Dai - Friday, August 9, 2019 7:53 AM -
0 Votes
MSmerge_Index_xxxxx missing on subscriber
I have 2 sites that have been replicating successfully for many years using a Merge Replication. We needed to add several new tables to the replication. I have added the tables in the ...Answered | 6 Replies | 313 Views | Created by jeff0411 - Wednesday, August 7, 2019 2:20 PM | Last reply by jeff0411 - Thursday, August 8, 2019 6:15 PM -
1 Votes
SQL Server Replication Options
We currently have three main sql servers. Server sql4 (on prem) is our Publisher and Distributor and does push transactional replication to servers sql3 (on prem) and sql7 (ec2 instance ...Unanswered | 6 Replies | 361 Views | Created by carlaromere - Monday, August 5, 2019 8:55 PM | Last reply by Edwin Liu 0302 - Thursday, August 8, 2019 8:54 AM -
0 Votes
sql server transaction replication network load
Hi Guys, We have enabled Transaction replication from Server A to Server B; We want to figure out how data is transferred in peak vs non peak ...Answered | 3 Replies | 328 Views | Created by Navind - Monday, August 5, 2019 6:32 PM | Last reply by Navind - Wednesday, August 7, 2019 4:31 PM -
0 Votes
Monitor Distributor Agent in Transnational Replication
Hi, I wanted to monitor the Distributor Agent's running status in Transnational Replication. I want to get alert when it is stopped. Tried to create alert for the ...Unanswered | 2 Replies | 289 Views | Created by Udham Singh - Tuesday, August 6, 2019 11:15 AM | Last reply by Udham Singh - Wednesday, August 7, 2019 5:08 AM -
0 Votes
Switch From Same Publisher-Distributor To Remote Distributor
Hi. I wanted to kindly ask if it's possible to switch from an already-working Transactional Replication where the Publisher is the same as the Distributor, to a setup where the ...Answered | 4 Replies | 708 Views | Created by BogdanU - Monday, August 5, 2019 11:07 AM | Last reply by BogdanU - Tuesday, August 6, 2019 2:14 PM - Items 1 to 20 of 11904 Next ›
