-
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 | 48146 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
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 ...Unanswered | 1 Replies | 35 Views | Created by Gumvert - 19 hours 32 minutes ago | Last reply by Hilary Cotter - 18 hours 38 minutes ago -
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 | 2464 Views | Created by Abdo Ahmed - Sunday, June 02, 2013 4:46 AM | Last reply by Hilary Cotter - Thursday, April 19, 2018 7:35 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 | 1 Replies | 86 Views | Created by MI00712 - Monday, April 16, 2018 6:55 AM | Last reply by Hilary Cotter - Monday, April 16, 2018 2:47 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 | 58 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 | 89 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 | 85 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 | 64 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 | 207 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 | 196 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 | 143 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 | 101 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 | 92 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 | 115 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 | 117 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 | 134 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 | 128 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 | 156 Views | Created by ARPRINCE - Thursday, March 29, 2018 3:59 PM | Last reply by ARPRINCE - Friday, March 30, 2018 2:59 PM -
0 Votes
SQL Server Replication-How to disable Replication in two redundant server
Hi, I am getting following error message when i disable replication between two servers. " The Procedure 'Sp_repicationdboption' cannot ...Proposed | 1 Replies | 82 Views | Created by Dinesh Lakshmanan - Friday, March 30, 2018 5:43 AM | Last reply by Hilary Cotter - Friday, March 30, 2018 2:03 PM -
0 Votes
Replication error
Hello, I am trying to get merge replication to work. I created the initial snapshot, when i run the replication I came across this error Query for data ...Proposed | 5 Replies | 212 Views | Created by Tautvydas N - Monday, March 12, 2018 11:31 AM | Last reply by Hannah Yu - Friday, March 30, 2018 9:17 AM -
1 Votes
Pausing and Restarting Single Subscriber Data Sync for Multi Subscriber Transactional Replication Environment
Distributor > Subscriber_1 Publisher > Distributor > Subscriber_2 Both Subscriber_1 and Subscriber_2 use same Publisher and ...Answered | 2 Replies | 118 Views | Created by Yuvraj Singh Bais - Thursday, March 29, 2018 11:43 AM | Last reply by Yuvraj Singh Bais - Friday, March 30, 2018 4:03 AM - Items 1 to 20 of 11566 Next ›
