3 4
Transactional replication can be used when subscribers need to be kept up-to-date with the publisher. Transactional replication can be configured so that the subscriber is updated shortly after the publisher is updated. Even when the Log Reader Agent is running continuously, it reads the transaction log every few seconds instead of constantly in order to lower overhead on the publisher's transaction log.
Transactional replication can also be configured so that the subscribers can also update the database. Because of this, transactional replication is highly flexible and has many uses. These uses consist of applications such as the following:
There are many applications for transactional replication. Depending on your system's configuration and your application, you might find transactional replication to be quite useful.