0
votes
1answer
84 views

SQL Server 2008R2 Transaction Replication Stop and Restart but continue log backups

In a database that is currently being replicated I want to stop the replication (stop the log reader process) for a period of time though I want to continue to take log backups on that same database. ...
1
vote
0answers
260 views

SQL Server distribution agent cleanup job causes blocking

I am using SQL Server transactional replication, and have noticed that on a daily basis all of the publications for a distributor are being blocked when the distribution agent cleanup job executes. I ...
0
votes
2answers
992 views

SQL Server 2008 R2 Replication log reader could not execute sp_replcmds

This log reader agent worked perfectly for several months until the user referenced in the error was removed from the domain. After that time the error 'The process could not execute 'sp_replcmds' on ...
0
votes
1answer
232 views

SQL 2008 R2 Bi directional replication

I'm looking for the right replication for my case: I can't use P2P replication because one of my SQL's is Standard. I have 2 SQL 2008 R2 and want to create a bi-directional replication. What are my ...
0
votes
1answer
122 views

SQL Transaction Replication prevents procedure with distinct on varchar(max)

When I'm adding one procedure article to the Publication the I get this error: The text data type cannot be selected as DISTINCT because it is not comparable the proc is a simple select distinct ...