Merge Agent - The Merge Agent is used with merge replication. It applies the initial snapshot to the Subscriber and moves and reconciles incremental data changes that occur. Each merge subscription has its own Merge Agent that connects to both the Publisher...
Distribution Agent - The Distribution Agent is used with snapshot replication and transactional replication. It applies the initial snapshot to the Subscriber and moves transactions held in the distribution database to Subscribers. The Distribution Agent...
Log Reader Agent - The Log Reader Agent is used with transactional replication. It moves transactions marked for replication from the transaction log on the Publisher to the distribution database. Each database published using transactional replication...
Snapshot Agent- The Snapshot Agent is used with all types of replication. It prepares the schema and the initial bulk copy files of published tables and other objects, stores the snapshot files, and records information about synchronization in the distribution...
)Describe in brief working of Replication. At first data and object is synchronized between publisher and subscribers.The snapshot is created on the publisher and transmitted to subscribers. All the subsequent changes on the publisher are stored in distribution...
Is it possible to run multiple publications and different type of publications from the same distribution database? Yes this can be done and there are no restrictions on the number or types of publications that can use the same distribution database....
Data is not being delivered to Subscribers, what can be the possible reasons? There are a number of possible causes for data not being delivered to Subscribers: The table is filtered, and there are no changes to deliver to a given Subscriber. One or more...
Is it possible to replicate data from SQL Server to Oracle? Yes this can be done using heterogeneous replication. In SQL Server 2000, publishing data to other databases such as DB2 or Oracle was supported; however, publishing data from other databases...
Is it possible to replicate data from SQL Server to Oracle? Yes this can be done using heterogeneous replication. In SQL Server 2000, publishing data to other databases such as DB2 or Oracle was supported; however, publishing data from other databases...
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? The easiest way to monitor replication activity and performance is to use replicationmonitor.To monitor replication, a user must be a member...
