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....
What is merge replication? This allows both publisher and subscriber to work independently, online or offline and merges the changes later. Here changes are track on both publisher and subscriber and then merged.
How does merge replication works? What are advantages and disadvantages of Merge replication? What is conflict resolution in Merge replication? What is a transactional replication?
What is a transactional replication? It is used when changes are frequent. The replication agent monitors the changes at the publisher and distributes the changes to the subscribers.Transactional Replication is required where up to date data is requi...
What are data type concerns during replications?
What are the uses of Replication? a) Server to Server Replication:- 1. Improving scalability and availability 2. Data warehousing and reporting 3. Integrating data from multiple sites 4. Integrating heterogeneous data 5. Offloading batch processing b)...
What are the Agents used for Transactional Replication? a) Snapshot Agent b) Log Reader Agent c) Distribution Agent 37)What are the Agents use
What is the Process of Transactional Replication? Three Agents are doing the Process for Transactional Replication
