SQL Server Replication announcement
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Sticky1Votes
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 ...4 Replies | 35086 Views | Greg Y - Thursday, December 07, 2006 8:22 PM | Last Reply Harry SQL DBA - Saturday, February 19, 2011 5:43 AM
-
Unanswered0Votes
P2P Replication and Update Stats
I had P2P Replication configured between 2 servers. The replication from Server 1 to Server 2 was working fine but the Replication from Server 2 to Server 1 was broken. I removed Replication ...1 Replies | 136 Views | B19 - Tuesday, June 18, 2013 8:53 PM | Last Reply Fanny Liu - 4 hours 17 minutes ago -
Unanswered1Votes
How to properly troubleshoot Merge Replication False Conflicts
Hi. We have SQL Server 2008 R2 Merge Replication setup. Lately I started getting conflicts for some tables, and when I check the conflict viewer, I can see that ...4 Replies | 68 Views | AdelKh - 21 hours 36 minutes ago | Last Reply AdelKh - 8 hours 26 minutes ago -
Unanswered0Votes
SQL Server Replication and enabling read_committed_snapshot on the distributor
Is there any documentation out there on enabling read_committed_snapshot isolation on the distribution database to reduce contention? I know it is mainly a lot of writes, but there appear to be a fair ...1 Replies | 58 Views | John Couch - 23 hours 54 minutes ago | Last Reply Hilary Cotter - 17 hours 52 minutes ago -
Proposed0Votes
Replication Snapshot.exe utilizing 90 GB of RAM and generating high Page Faults / sec. (realm of 140k)
Does snapshot replication utilize the windows file copy cache? I have seen something similar when copying larges files around. In the shot below the memory usage had dropped but the Hard Pae ...2 Replies | 61 Views | John Couch - 19 hours 29 minutes ago | Last Reply Hilary Cotter - 17 hours 57 minutes ago -
Proposed0Votes
how to resolve the corrupted Quorum drive in sql server 2008 cluster?
Hi All, I have small query on Quorum drive . If Quoram drive will corrupted ,what is impact on SQL server cluster instances or nodes? How to ...3 Replies | 99 Views | TSRam - Saturday, June 22, 2013 5:29 AM | Last Reply Hilary Cotter - 18 hours 1 minutes ago -
Unanswered0Votes
peer to peer replication
Hi All, I have few doubts on peer to peer replication, actually i am new to p2p replication. can u please explain the work flow of p2p replication and what are ...4 Replies | 154 Views | TSRam - Wednesday, June 19, 2013 11:07 AM | Last Reply Hilary Cotter - Saturday, June 22, 2013 4:30 PM -
Unanswered0Votes
msdtc has corrupted in cluster 2008 server ?
Hi All, I have faced different issue in cluster server 2008. unfortunately MSDTC has corrupted on windows 2008 server(cluster). my query ...1 Replies | 60 Views | TSRam - Saturday, June 22, 2013 4:43 AM | Last Reply Hilary Cotter - Saturday, June 22, 2013 4:26 PM -
Answered0Votes
DDL Changes to Article (ALTER TABLE ADD COLUMN) not propagated to subscriber table, article converted to column filtering in SQL Server 2008 (Transactional Replication).
I added many columns to a table in replication via "ALTER TABLE ADD", all of datatypes INT, TINYINT, DECIMAL and DATETIME and all NULL. The DDL changes were NOT replicated to the ...4 Replies | 129 Views | David Zamula - Wednesday, June 19, 2013 9:49 PM | Last Reply David Zamula - Friday, June 21, 2013 1:59 PM -
Answered0Votes
Transactional Replication Filter SQL Server 2008 R2
Hi , I have a requirement to publish a set of records in a table. The data is something like select * from Table_Monit ...3 Replies | 92 Views | SQLmaddy - Thursday, June 20, 2013 1:54 PM | Last Reply Hilary Cotter - Thursday, June 20, 2013 3:32 PM -
Answered1Votes
Add article to Merge replication without having to set @force_invalidate_snapshot = 1
I am adding 4 articles to a Merge publication. Each Article has the @subset_filterclause set with the same SELECT statement. When I try to run the code, SQL Server is informing me ...1 Replies | 83 Views | eguman - Thursday, June 20, 2013 3:03 PM | Last Reply Brandon Williams - Thursday, June 20, 2013 3:17 PM -
Unanswered0Votes
Subscriber is not getting created in SQL Replication
Hi I am using SQL Server 2008 R2 for using the feature of SQL Replication, i have two different servers where I am using the first server as the publisher and the second one as the ...3 Replies | 109 Views | Kiran Julakanti - Wednesday, June 19, 2013 7:20 PM | Last Reply Tom Phillips - Thursday, June 20, 2013 1:25 PM -
Unanswered0Votes
Push subscription across a one way trust to a different domain
Hey all, I have a sql 2008 R2 instance that I'm attempting to setup replication of several tables to a SQL 2012 server in a different domain . I need to use a push ...8 Replies | 354 Views | Portojep - Thursday, May 23, 2013 9:12 PM | Last Reply vijay_1234 - Thursday, June 20, 2013 1:10 PM -
Discussion0Votes
Generated Replication Publication Script adds pull subscription at the end
R, J2 Replies | 213 Views | Crakdkorn - Friday, June 14, 2013 8:49 PM | Last Reply Crakdkorn - Thursday, June 20, 2013 2:50 AM -
Answered0Votes
SQL Server 2008 Replication with Large Sets of Data
Hello, I have a few questions regarding SQL replication and how it handles large sets of data. We are exploring different options to offload reporting from the OLTP ...2 Replies | 107 Views | Steve Moran - Wednesday, June 19, 2013 5:52 PM | Last Reply Steve Moran - Wednesday, June 19, 2013 7:11 PM -
Discussion0Votes
Merge replication loops when replicating records are more than set limit
Hi We have merge replication setup. The default amount of records it will try to replicate is 10 000. If I update 11 000 records on the publisher, it replicates 10 902 and then 10 ...4 Replies | 107 Views | Dolfie99 - Wednesday, June 19, 2013 8:36 AM | Last Reply Dolfie99 - Wednesday, June 19, 2013 2:07 PM -
Proposed0Votes
Log Shipping question...Can I recreate a log backup to "catchup" my Log Shipping Restore...?
First off, I hope I'm posting to the correct forum as I didn't see a "Log Shipping" forum, and I have a Log Shipping question. I accidentally deleted several ...2 Replies | 123 Views | Roshall - Tuesday, June 18, 2013 7:31 PM | Last Reply Roshall - Tuesday, June 18, 2013 8:40 PM -
Answered0Votes
Transactional replication - merge command performance
Hello, I'm trying to find a solution to one performance issue with replication that I'm facing at the moment, so I'm hoping someone here could help. I ...4 Replies | 264 Views | Miljan Komatina - Tuesday, June 11, 2013 8:42 AM | Last Reply Fanny Liu - Tuesday, June 18, 2013 7:43 AM -
Answered0Votes
Moving REPLDATA folder cause reinitialization?
Does moving the repldata folder location require reinitializing replication? John M. Couch2 Replies | 184 Views | John Couch - Monday, June 17, 2013 10:30 AM | Last Reply ione721 - Monday, June 17, 2013 10:17 PM -
Unanswered0Votes
Database Mirroring Monitor Job
I believe that Database Mirroring Monitor Job was created when we were experimenting with mirroring. Is it safe to drop the job? Will getting rid of the job affect our (snapshot) ...4 Replies | 196 Views | jameslester78 - Monday, June 17, 2013 11:04 AM | Last Reply Hilary Cotter - Monday, June 17, 2013 5:14 PM -
Unanswered0Votes
Initialize from LSN doesn't work
Hi, For some reason we cannot initialize from LSN in a mirrored setup. We have 3 servers and push replicate from A to B, SRVB and C are setup with database ...7 Replies | 295 Views | MJ2012 - Friday, June 07, 2013 7:17 AM | Last Reply MJ2012 - Monday, June 17, 2013 7:50 AM - Items 1 to 20 of 9169 Next ›