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 ...
-
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: ... -
Proposed0Votesadd a new subscription to an existing publication
We are using SQl 2008 push replication and distributor is on its own physical server. We have an existing publication and one subscriber already established and running in production. ... -
Unanswered0Votescan't add new column to table in replication
I have a merge replication running and when I try to alter table with this commancd: alter table mytable add cTestColumn nvarchar(10) getting this ... -
Unanswered0Votesreplication settings for a table that has high insert rate
We have set up a push publication for a single large article which has high insert rate. We are in SQL 2008 enterprise. This table has over billion rows and has an insert rate of ... -
Answered0VotesPeer to Peer Replication 2008 <> 2012
Hi I am a vb Developer trying to investigate the ability of adding an sql server 2012 node into an existing peer to peer replication of 2 nodes running sql server 2008. I cannot ... -
Answered0Voteswhat does a delicated distributor server use RAM for?
We are setting up a push transaction replication with a dedicated distributor server in 2008 R2 enterprise and wondering how the distributor is using the RAM. What are the ... -
Proposed0VotesAgent message code 21100:replication job was running fine till yesterday without having such permission on folder now how suddenly job is getting failed?
Our replication job was getting failed with below error. To resolve this issue I have granted write permission to agent account on COM folder. Now job is running fine. Error:Agent ... - Items 1 to 20 of 9156 Next ›


