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 | 36648 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
-
Answered0Votes
log shiping
i am setting up log shipping for about 30 dbs, everything working fine, i need to log ship structure/objects of a db not data. is it possible in log ...2 Replies | 394 Views | Created by Vaishu - Tuesday, April 02, 2013 2:23 PM | Last reply by Marshal Bennett - 4 hours 42 minutes ago -
Unanswered0Votes
How to generate peer-to-peer stored procedures through a script?
Hello, I'm trying to set up peer to peer replication entirely through scripts, but I'm having troubles with creation of all the sp_MSins_..., sp_MSdel_... and ...1 Replies | 100 Views | Created by Tadeusz - Friday, August 30, 2013 8:01 PM | Last reply by Kevin Urquhart - Saturday, August 31, 2013 9:11 AM -
Answered0Votes
Change Data Capture (CDC) on replication database
Hi Team, Can I ENABLE the Change Data Capture(CDC) feature on Subsription Database and its associated replicated tables? Should I have to consider any ...3 Replies | 602 Views | Created by Dhanu V - Tuesday, March 12, 2013 2:47 AM | Last reply by ls291 - Saturday, August 31, 2013 7:49 AM -
Unanswered0Votes
SQL replication or SSIS using CDC
Hi All, Can anyone let me know which method is better for replicating data from oracle to SQL Server.whether its SQL Replication(i.e publisher,distributer,subscriber) or using SSIS ...4 Replies | 110 Views | Created by ls291 - Tuesday, August 27, 2013 6:23 PM | Last reply by ls291 - Saturday, August 31, 2013 6:51 AM -
Answered2Votes
index added but never replicated
I have created a new Index on one of the columns, the table belongs to this column is replicated, after adding new index, this index is not ...3 Replies | 107 Views | Created by '''HuuM''' - Friday, August 30, 2013 1:53 AM | Last reply by Hilary Cotter - Friday, August 30, 2013 4:09 PM -
Unanswered0Votes
Replication between SQL servers (2000 and 2012) without VPN
Hello, Until today we used routers and static ip's to make a vpn between the two computers we wanted to have the replication. But in this case this is not possible because ...1 Replies | 90 Views | Created by Jcp addict - Friday, August 30, 2013 9:55 AM | Last reply by Hilary Cotter - Friday, August 30, 2013 3:16 PM -
Answered0Votes
Republishing in a DR scenario
Hi All, I'm working with SQL Server 2008 R2 Enterprise. I was just reading about Republishing as a way to keep a DR site up to ...3 Replies | 133 Views | Created by Michael_G - Monday, August 26, 2013 5:24 PM | Last reply by Hilary Cotter - Friday, August 30, 2013 3:13 PM -
Answered1Votes
How to map a value of the __$update_bitmap column in the conflicts table of peer-to-peer replication to actual columns?
Hello, I need to programatically resolve conflicts in peer-to-peer replication and for that I need to now which columns in a particular data table were causing the conflicts. ...2 Replies | 119 Views | Created by Tadeusz - Tuesday, August 27, 2013 12:35 PM | Last reply by Tadeusz - Friday, August 30, 2013 11:05 AM -
Unanswered2Votes
Merge Replication, Delete is working at publisher(if a row is deleted at publisher then its getting updated at subscriber) and not working at subscriber(if a row is deleted at subscriber then its not getting updated at publisher)?
Hi, We've merge replication configured in our environment(4 SQL servers 2008R2). As we know merge replication is bidirectional, its working fine in case of ...9 Replies | 158 Views | Created by wilshere - Wednesday, August 28, 2013 9:16 PM | Last reply by wilshere - Friday, August 30, 2013 9:24 AM -
Proposed0Votes
Could not drop object 'dbo.Individual' because it is referenced by a FOREIGN KEY constraint. (Source: MSSQLServer, Error number: 3726)
Hello , I know above error because of FOREIGN KEY constraint , i dont want to remove foreign key at both the end and want source table as it is to ...1 Replies | 70 Views | Created by Rahul Hundare - Friday, August 30, 2013 7:01 AM | Last reply by Latheesh NK - Friday, August 30, 2013 7:13 AM -
Answered0Votes
The schema script 'Office_488.sch' could not be propagated to the subscriber.
I am new in Merge replication and don't know where to get help. i have two databases on same server and one is working fine and secondone is giving me below error. Althought ...7 Replies | 1110 Views | Created by MalikJaved - Wednesday, February 20, 2013 4:18 PM | Last reply by Rahul Hundare - Friday, August 30, 2013 6:54 AM -
Answered0Votes
Custom Resolver Stored Procedure
= LEN(@ServiceNotesConflict) Begin Select @ServiceNotesUsed = ...7 Replies | 934 Views | Created by Del at Equisoft - Tuesday, November 13, 2012 2:50 PM | Last reply by douglasle - Friday, August 30, 2013 3:28 AM -
Unanswered0Votes
Merge Replication Resolving Conflicts for SQL Server 2008
Hi, Can anyone help me with my issue... I have one (merge) publication (data are managed from, in my case, web application) with several subscribers (data are ...5 Replies | 1230 Views | Created by StefanMKD - Monday, February 04, 2013 12:22 PM | Last reply by douglasle - Friday, August 30, 2013 2:56 AM -
Unanswered0Votes
Length of LOB data to be replicated exceeds configured maximum 65536 on only 1 subscriber
Hi All, Scenario: 1 publisher & 2 transactional replication subscribers (all SQL 2005) I am getting the below error on publisher for one of ... -
Unanswered0Votes
SQL Replicate a certain time range
Hello helpful community, :) I have a question about replication / logshipping. Our situation: We have old, big databases on an current ...1 Replies | 97 Views | Created by Dennis Kloppenburg - Wednesday, August 28, 2013 11:17 PM | Last reply by Hilary Cotter - Thursday, August 29, 2013 7:21 PM -
Proposed0Votes
Replication between SQL Server 2008 R2 (server) and SQL Server 2008 R2 Express (Win7) is finally working, but ...
With the help of MANY online articles, I finally have SQL Server 2008 R2 now replicating correctly to a SQL Server 2008 R2 Express database on a Windows 7 machine but when I started testing my Access ...1 Replies | 84 Views | Created by AncientDigitalDude - Thursday, August 29, 2013 5:50 PM | Last reply by Hilary Cotter - Thursday, August 29, 2013 6:09 PM -
Unanswered0Votes
Snapshot will not run
I am trying to create a new publication on a SQL 2008R2 instance that already has two publications running successfully. When the snapshot agent kicks in it is failing. The job created has the ...15 Replies | 108 Views | Created by Brian McCashin - Thursday, August 29, 2013 2:34 PM | Last reply by Tom Phillips - Thursday, August 29, 2013 5:34 PM -
Proposed0Votes
Merge agent may fail during merge replication
Hello, We received the following error on a subscribers agent "The Merge Agent failed after detecting that retention-based metadata cleanup has deleted ...3 Replies | 184 Views | Created by JeremyParks - Friday, August 23, 2013 8:36 PM | Last reply by JeremyParks - Thursday, August 29, 2013 5:07 PM -
Answered0Votes
Peer to Peer replication migration
Hello guys, We have a two MSSQL instances SQL 2008 R2 Enterprise with established peer to peer transactional replication between ...7 Replies | 130 Views | Created by Stefan Boychev - Wednesday, August 28, 2013 8:19 AM | Last reply by Hilary Cotter - Thursday, August 29, 2013 4:39 PM -
Answered1Votes
SQL Server 2012 Merge Replication - Delete operations on Merge Tables now require ALTER TRACE permisson due to Extended Stored Proceedure call master..sp_repl_generateevent. Some Advise would be appreciated.
Hi All, In reference to http://dba.stackexchange.com/questions/29141/why-do-replication-deletes-require-sysadmin-access I have the same issue as reported in ...15 Replies | 144 Views | Created by killerchef - Monday, August 26, 2013 8:53 AM | Last reply by killerchef - Thursday, August 29, 2013 6:45 AM - Items 1 to 20 of 9361 Next ›