Replication

Código de error: 22903, texto: “Ya hay otra conexión ejecutando ‘sp_replcmds’ para la captura de datos modificados en la base de datos actual.”

by

Recientemente me enfrenté a un escenario muy interesante en el que para una base de datos se habilitaban tanto la captura de datos modificados como la replicación transaccional. Según la documentación de MS, ambas funciones pueden funcionar juntas, pero debemos tener algunas cosas en cuenta al implementar ambas funciones juntas en una base de datos. En … Read more

Snapshot getting applied repeatedly

by

Recently I was faced with an interesting issue where upon rerunning distributor agent, complete snapshot was being applied even though we had got “snapshot has been delivered successfully” message. The activity was about adding newly created tables into the replication. Below were high level steps followed for the activity. After step 5, once we got … Read more

SQL Server Replication Error 113 – Missing end comment mark ‘*/’

by

Replication is one of the trickiest things in SQL Server and especially when you don’t know the solution of the issue. One such issue we faced a few days back which we were able to solve using a small trick. Here is what happened.: Snapshot got generated on publisher but failed to apply on subscriber. … Read more

Row was not found at the Subscriber

by

We got one replication related alert for one of the critical database. Distribution agent was failing with below error message: The row was not found at the Subscriber when applying the replicated DELETE command for Table ‘[dbo].[TableXXX]’ with Primary Key(s): [PrimaryKeyID] = 12345678 (Source: MSSQLServer, Error number: 20598) Above error could be seen in replication … Read more

Log file full due to snapshot replication

by

Log File Truncation Pending for Replication in Snapshot Replication

Understanding Files created by Replication Snapshot Agent

by

In Previous article, we discussed – Where Are various Replication Agent Jobs Running ? This is very important for quick troubleshooting of replication issues. In this article, we will try to understand various files created by Snapshot Agent when a Snapshot is created. If we go to snapshot folder (Check location in Publication Properties), we … Read more

Where Are Replication Agent Jobs Running ?

by

SQL server Replication is one of the most interesting topic. Transactional Replication is most widely used for various purposes. When any issue related to Transactional replication occurs, many DBAs face difficulty in identifying locations of Replication Agent Jobs. Snapshot Agent, Log Reader Agent & Distribution Agent are three main replication related jobs whose history need … Read more