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...
Can you tell me some of the common replication DMV's and their use? sys.dm_repl_articles - Contains information about each article being published. It returns data from the database being published and returns a row for each object being published in...
What are publisher, distributor and subscriber in “Replication”? Publisher-A publisher is any database unit that makes data available to other sources via replication. The publisher can have multiple publications which defines the data to replicate. Subscriber-A...
What is “Push” and “Pull” subscription? Pull Subscription : In a pull subscription, changes to a subscriber cannot be publicized without any request from subscriber. This allows the user at the Subscriber to determine when the data changes are synchronized....
