• Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

Card Range To Study

through

image

Play button

image

Play button

image

Progress

1/12

Click to flip

Use LEFT and RIGHT arrow keys to navigate between flashcards;

Use UP and DOWN arrow keys to flip the card;

H to show hint;

A reads text to speech;

12 Cards in this Set

  • Front
  • Back
What sort of articles can replication use?
Tables
Views
Filtered tables/views (selection)
Indexed Views
Stored procedures (definition/execution)
What is the hierarchy of objects in replication?
The publisher server sends a publication of articles to a single distributor (which can be the same server), which provides the data to subscribers that can access that data.
When is a push subscription better?
When there's stable and permanent connections: It provides management simplicity.

Downside: Uses more hardware resources, especially when there's lots of subscribers.
What are the characteristics of snapshot replication?
Resembles backup and restore: At scheduled times, the full set of articles is re-copied to each subscriber.
Best for small and static data.
What are the characteristics of transactional replication?
The transaction log is sent to the subscribers to perform the same changes as in the original database(s).

Handles changing data better than snapshot replication, but limits data changes at the destination (subscriber?) and a separate communicator is required to update from subscriber to publisher.

Includes peer-to-peer replication, which CAN handle simultaneous changes.
What are the characteristics of merge replication?
Both subscriber and publisher can change data simultaneously: Changes are captured by the merge program with ID columns, triggers, and tables, and conflicts between changes are resolved with a given method before the changes are applied.

Due to the checks and schema requirements, it's more invasive and resource-intensive(?) than other replication methods.
How are replication agents managed?
By default, implemented through agent jobs: SSMS replication wizard automates creation, and SSRM/SSMS can manage or maintain them after creation (with other jobs).

Can also be run from command line or RMO applications.
What are the snapshot agent's properties and uses?
snapshot.exe

Prepares schema and initial full backup copy to start replication, or repair anomalies in the data (i.e. recopy if something screws up).

Runs on the Distributor server (origin).
What are the properties and uses of log reader agent?
logread.exe

Monitors and copies transaction logs to distributor, which sends to subscriber.

Runs on the publisher (second), automatically shared/reused for changes to the same database to different publications. Transactional only.
What are the properties and uses of distrubution agent?
distrib.exe

Delivers initial snapshot to the subscribers and sends/applies transaction log changes. The Changer.

Runs in the initiator of sending depending on push or pull subscription: Distributor for push, subscriber for pull.
What are the characteristics and uses of merge agent?
replmerg.exe

Sends snapshot from distributor to subscriber (2nd), merges data changes from both ends.

Runs in the secondary sender depending on push/pull: Distributor for push, subscriber for pull.
What are the characteristics and uses of queue reader agent?
qrdrsvc.exe
(Cut the vowels)

Reads and applies transaction changes from queues when snapshot or transactional is set up to use queues: Independent of publisher/distributor/subscriber hierarchy?