Real-World Transactional Replication Problems and Solutions
This section discusses some of the common real-world transactional replication problems that may occur in a transactional replication configuration. There are no specific patterns for these problems. Almost all of these problems can be solved without having to reconfigure the replication.
Transactional replication doesn't require that much management once configured. However, you'd have to look at issues that may occur from time to time. In this section, we'll look at some of those issues.
We can group these issues under the following categories:
Configuration issues
Data issues
Performance issues
Note
This categorization is done for understanding, and is not the standard categorization from Microsoft. This lesson doesn't cover all issues. It covers common issues and explains the solutions to them in a way so that you can fix other issues.
Configuration Issues
As the name suggests, these are issues that may occur if transactional replication...