-
2 Votes
Reminder - 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 | 48154 Views | Created by Greg Y - Thursday, December 07, 2006 8:22 PM | Last reply by Harry SQL DBA - Saturday, February 19, 2011 5:43 AM
-
0 Votes
Drop rogue Subscription issue.
Greetings. We're having an issue dropping a Subscription on the Subscriber database, even though the Publication has already been removed from the Publisher. We're not sure how we ...Answered | 10 Replies | 187 Views | Created by ChrisRDBA - Monday, March 19, 2018 6:33 PM | Last reply by ChrisRDBA - 18 hours 25 minutes ago -
0 Votes
Timeout error on snapshot
I have a post snapshot script that gets applied after the snapshot is loaded to the subscriber whenever I reinitialize my replication, few times I keep getting the query timeout errors ...Answered | 3 Replies | 40 Views | Created by prudhvi1589 - Monday, April 23, 2018 5:36 PM | Last reply by prudhvi1589 - Monday, April 23, 2018 9:56 PM -
1 Votes
Article addition causes severe locking,High waiting task in SQL server 2016 Transactional Replication
Problem Description: Unusual High Waiting Tasks & Sudden dip in CPU usage with lots of locking while try to add an article Table(s) in an existing Transactional Replication ...Unanswered | 2 Replies | 134 Views | Created by MI00712 - Monday, April 16, 2018 6:55 AM | Last reply by Bartosz Lewandowski - Monday, April 23, 2018 4:29 PM -
0 Votes
CDC to offload operational database - Need f a read-only replica
Hi experts I need to replicate an operational database to offload it from ad-hoc reporting and other readonly operations. These adhoc queries sometimes take 50% of the ...Unanswered | 3 Replies | 52 Views | Created by uldoman - Monday, April 23, 2018 11:23 AM | Last reply by Hilary Cotter - Monday, April 23, 2018 4:25 PM -
0 Votes
Merge Replication failover
Hi, I have merge replication between 4 databases where one is publisher and the rest are subscribers but if publisher is down replication stops. Are there any ways to prevent one point of failure to ...Answered | 1 Replies | 54 Views | Created by Gumvert - Friday, April 20, 2018 1:42 PM | Last reply by Hilary Cotter - Friday, April 20, 2018 2:36 PM -
0 Votes
Can i clear the content of "MSmerge_past_partition_mappings" ?
What will happen if i deleted the content of "MSmerge_past_partition_mappings" metadata table ? I think it should be fine, since it stores old tracking ...Unanswered | 12 Replies | 2477 Views | Created by Abdo Ahmed - Sunday, June 02, 2013 4:46 AM | Last reply by Hilary Cotter - Thursday, April 19, 2018 7:35 PM -
0 Votes
Strange error in Profiler while trying to diagnose another issue.
Folks, I'm trying to diagnose a completely separate issue(or it may be not but we'll see) related to web merge replication. The environment is a SQL 2008 R2 server and separate web ...Answered | 2 Replies | 68 Views | Created by andyew - Monday, April 16, 2018 3:55 AM | Last reply by Martin.Cairney - Monday, April 16, 2018 12:29 PM -
0 Votes
Transaction replication
Hi We have Transaction replication has configured from 2008 R3 to 2014 (pull subscriptions) . Technically working fine. Now I need to configure other replication from same prod DB on ...Proposed | 3 Replies | 105 Views | Created by ashwan - Monday, April 09, 2018 1:29 PM | Last reply by Hilary Cotter - Friday, April 13, 2018 2:18 PM -
0 Votes
Why is Subscriber consistently using 25GB RAM?
Hi everyone, I'd like to preface this by saying that this is the first time I've set up replication in any form, and as such I'm at a loss as to why my subscriber DB instance is ...Unanswered | 2 Replies | 95 Views | Created by C Backlund - Wednesday, April 11, 2018 9:41 PM | Last reply by Hilary Cotter - Thursday, April 12, 2018 2:24 PM -
0 Votes
DR for On-premise Hyper V Clustered SQL servers and NLB based Web app Server for Azure with 15 minutes of replication
I am looking for DR option for On-premise Clustered SQL servers and NLB based Web app Server for Azure with 15 minutes of replication but on Azure all VM's should not be running ...Proposed | 1 Replies | 73 Views | Created by sunilsharma2012 - Thursday, April 12, 2018 4:55 AM | Last reply by Pirlo Zhang - Thursday, April 12, 2018 9:54 AM -
0 Votes
Merge Replication SP Conflict Resolver
Hi All, Running SQL Server 2008 R2 in a merge replication topology with pull subscriptions. Publisher and Distributor are on same machine. ...Unanswered | 10 Replies | 217 Views | Created by 2012S4 - Friday, March 30, 2018 2:37 AM | Last reply by Hilary Cotter - Monday, April 09, 2018 7:01 PM -
0 Votes
Data replication question
We are planning to do the following: 1. Create a new database with SQL 2016 Ent edition 2. Replicate data from this new SQL 2016 db to existing SQL 2008R2 env, ...Unanswered | 6 Replies | 209 Views | Created by sqldev1 - Thursday, April 05, 2018 4:00 AM | Last reply by Hilary Cotter - Monday, April 09, 2018 2:28 PM -
0 Votes
SQL Replication reg.
We have 4 SQL server 2008 version we have transaction replication between A pair of DB / Server and Pair of SQL mirror between 2 Db Servers. Kindly the see Present scenario of ...Proposed | 5 Replies | 160 Views | Created by Jagskml - Tuesday, March 27, 2018 6:58 AM | Last reply by Tom Phillips - Monday, April 09, 2018 1:13 PM -
0 Votes
snapshot delivered, then reapplied
I initialized transactional replication from a current snapshot, waited 9 hours while the snapshot was applied and received the message that the snapshot had been successfully delivered. While I ...Unanswered | 4 Replies | 109 Views | Created by JayMeerdink - Monday, April 02, 2018 1:48 PM | Last reply by JayMeerdink - Thursday, April 05, 2018 2:57 PM -
0 Votes
Merge Replication what is the order of processing of downloaded pre sch bcp files at Subscriber?
I'm not sure I'm going to get too much help here as this is really in the bowels of SQL Merge Replication but here goes. I have two publications. One that contains tables. Works ...Answered | 2 Replies | 98 Views | Created by andyew - Wednesday, April 04, 2018 2:42 AM | Last reply by andyew - Thursday, April 05, 2018 2:14 AM -
1 Votes
Test handling SQL replication errors. RAISERROR seems to not work with MSSQL_REPL errors numbers
Folks, I'm not specifically after assistance with the error I'm dealing with although if someone has a clue to fix the actual issue that would be great. My question relates to ...Unanswered | 2 Replies | 126 Views | Created by andyew - Wednesday, March 28, 2018 4:51 AM | Last reply by andyew - Wednesday, April 04, 2018 2:19 AM -
0 Votes
Tran. replication best practice
Are there any best practices for setting up article properties of "statement deliver" for update / delete / insert. I assume by default SQL Server executes bunch of internal stored ...Proposed | 3 Replies | 123 Views | Created by ManOfSteel75 - Friday, March 30, 2018 4:41 PM | Last reply by Hilary Cotter - Tuesday, April 03, 2018 2:43 AM -
0 Votes
SQL Replication - rebuilding MSReplication_Objects indexes and Stats system tables.
Fellow SQLers I have a subscription database that I have built index rebuilds and stats updates that will run weekly. As a best practice for my indexing stats routine, I ...Answered | 3 Replies | 144 Views | Created by mg101 - Sunday, April 01, 2018 2:53 PM | Last reply by Hilary Cotter - Monday, April 02, 2018 3:11 PM -
0 Votes
difference bwn distribution property vs publication property
can someone tell me difference between distribution agent property of "Transaction retention" and "history retention" period VS the publication property of "Subscription ...Unanswered | 3 Replies | 134 Views | Created by ManOfSteel75 - Thursday, March 29, 2018 1:46 AM | Last reply by Hilary Cotter - Friday, March 30, 2018 3:11 PM -
3 Votes
eMail Notification for Agent Job Failure
New to replication. I see that when you create transactional replication, it creates several jobs related to it below (Publisher + Distributor + Subscriber). My question is, which ...Unanswered | 4 Replies | 165 Views | Created by ARPRINCE - Thursday, March 29, 2018 3:59 PM | Last reply by ARPRINCE - Friday, March 30, 2018 2:59 PM - Items 1 to 20 of 11568 Next ›