SQL Server Replication announcement
Filter
:
All Threads
All Threads
Answered
Unanswered
Proposed Answers
General Discussion
No Replies
Helpful
Has Code
All Languages
-
Sticky1VotesReminder - 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 ...
-
Unanswered0VotesDDL 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 ... -
Unanswered0VotesSubscriber 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 ... -
Answered0VotesSQL 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 ... -
Unanswered0Votespeer 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 ... -
Discussion0VotesMerge 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 ... -
Unanswered0VotesP2P 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 ... -
Proposed0VotesLog 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 ... -
Answered0VotesTransactional 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 ... -
Answered0VotesMoving REPLDATA folder cause reinitialization?
Does moving the repldata folder location require reinitializing replication? John M. Couch -
Unanswered0VotesDatabase 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) ... -
Unanswered0VotesInitialize 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 ... -
Unanswered0Votesinitialize from lsn and Initialize with Backup Difference
Kindly tell us something about initialize from lsn and Initialize with Backup as there very less knowledge available on scenarios. Manish -
Unanswered0Votesmergreplication does not longer work
We have a mergereplication between different site W2008 Server and SQL Server 2008 R2. The replication stopped wit the following error Can not ... -
Unanswered0Votesreplication
expand the local publications -> there will 2 publications. Right click on each->view snapshot agent status->check the generate snapshot option ->click ok. do the same for another ... -
Discussion0VotesVery slow replication
10ms: 3 Total Time Request Blk(ms): 1581352 P2P Work Time (ms) : 0 P2P Cmds ... -
Unanswered0VotesErrors in Replication
Hi, we are facing 'out of syncs' in our Replication (transactional with updateable Subscribers) I checked MSrepl_errors and did a join to MSREPL_Commands over ... -
Unanswered0VotesArticle with a filter: Instead of updating, it is deleting rows at subscriber
EXEC sp_addarticle @publication = N'Sales_db__TranRepl', @article = N'DummyTable' , @source_owner = N'dbo', @source_object = N'DummyTable', @type = N'logbased', @description = N'' , ... -
Answered0VotesSQL Server 2012 as Subscriber to SQL Server 2008 R2 Snapshot
While this is certainly not the situation I would recommend or prefer, I have a situation that I may have to TEMPORARILY have an newer SQL Server running 2012 be a Subscriber for an SQL Server ... -
Answered0VotesSnapshot Replication fails - ALTER TABLE statement conflicted with the FOREIGN KEY constraint
Hi Everyone, i have a strange problem when using Snapshot Replication on a Microsoft SQL Server 2012 - 11.0.2100.60 (X64) Standard Edition on Windows NT 6.1 <X64> (Build 7601: ... - Items 1 to 20 of 9162 Next ›


