You are previewing Fundamentals of SQL Server 2012 Replication.
O'Reilly logo
Fundamentals of SQL Server 2012 Replication

Book Description

Fundamentals of SQL Server 2012 Replication provides a hands-on introduction to SQL Server replication. The book begins with a short overview that introduces you to the technologies that make up replication. In the following chapters, the book will walk you through setting up different replication scenarios. All hands-on exercises are designed with security best practices in mind. When you're finished working through the exercises, you will be able to implement your own multi-server replication setup while following the principle of least privilege.

Table of Contents

  1. Cover Page
  2. Title Page
  3. Copyright Page
  4. Table of Contents
  5. Foreword
  6. About the Author
  7. Acknowledgments
  8. Introduction
  9. Chapter 1: Overview of SQL Server Replication
    1. Putting SQL Server Replication to Work
    2. Replication Components
      1. Articles
      2. Publications
      3. Publication Database
      4. Publisher
      5. Distributor
      6. Distribution Databases
      7. Subscriber
      8. Subscriptions
      9. Subscription Databases
      10. Replication Agents
      11. Replication Maintenance Jobs
    3. How Terms are Used
    4. Replication Types
      1. Snapshot Replication
      2. Transactional Replication
      3. Merge Replication
    5. Summary
  10. Chapter 2: Configuring a Basic Replication Setup
    1. Setting Up the Distributor
    2. Setting Up a Publication
    3. Setting Up a Subscription
    4. Success!
    5. Summary
  11. Chapter 3: The Role of the Distributor
    1. Distribution Components
      1. The Distribution Database
      2. The Snapshot Folder
      3. The Replication Agents
    2. Best Practices
    3. Setting Up Distribution
      1. Removing Replication
      2. Setting up the Distributor
      3. Setting up Distribution on the Publisher
      4. Implementing Multiple Distribution Databases
    4. Summary
  12. Chapter 4: Transactional Replication – the Replication Agents
    1. Replication Agents
      1. Snapshot Agent
      2. Log Reader Agent
      3. Distribution Agent
    2. Summary
  13. Chapter 5: Transactional Replication – the Publication
    1. Preparing to Create a Publication
      1. Creating a Database
      2. Enabling a Database for Replication
    2. Creating a Publication
      1. Setting up your Database
      2. Setting up your Articles
      3. Setting up the Initial Snapshot
      4. Setting up Security
      5. Completing the Publication Setup
    3. Potential Problems
    4. Summary
  14. Chapter 6: The Publication Access List
    1. Setting Up a Subscription
    2. Configuring the Publication Access List
    3. Creating the Subscription
    4. Summary
  15. Chapter 7: Transactional Replication – the Subscription
    1. Setting up a Subscription
      1. Connecting to the Publisher
      2. Selecting the Distribution Agent location
      3. Specifying the Subscriber and the Subscription Database
      4. Configuring Security on the Distribution Agent
    2. Account Permissions
    3. Finalizing the Subscription
    4. Configuring Retention
      1. Configuring Retention on the Distributor
      2. Configuring Retention on the Publisher
    5. Summary
  16. Chapter 8: SQL Server Agent Jobs for Transactional Replication
    1. SQL Server Agent Jobs
      1. Snapshot Agent Jobs
      2. Log Reader Agent Job
      3. Distribution Agent Jobs
      4. Replication Maintenance jobs
    2. Creating the SQL Server Agent Jobs
      1. Local Distribution
      2. Remote Distribution
      3. Publication
      4. Push Subscription
      5. Pull Subscription
    3. Summary
  17. Chapter 9: Merge Replication – the Replication Agents
    1. Merge Replication Components
      1. Snapshot Agent
      2. Triggers, Tables, and Views
      3. Merge Agent
    2. Summary
  18. Chapter 10: Merge Replication – the Publication
    1. Enabling a Database for Merge Replication
    2. Creating a Publication
      1. Adding a Publication
      2. Adding Articles to your Publication
      3. Configuring the Snapshot Agent
      4. Finalizing your Publication
    3. Potential Problems
    4. Summary
  19. Chapter 11: Merge Replication – the Subscription
    1. Setting up a Subscription
      1. Selecting the Publisher
      2. Selecting the Merge Agent Location
      3. Specifying the Target Database
      4. Configuring Security
      5. Setting up Permissions
      6. Setting up the Schedule
      7. Initializing the Subscription Database
      8. Selecting the Subscription Type
      9. Finishing up your Subscription
    2. Setting Up Your Subscription's Retention
    3. Synchronizing Your Subscription Manually
    4. Summary
  20. Chapter 12: Merge Replication – Conflicts
    1. Conflict Types
    2. Configuring the Tracking Level
      1. Row-level Tracking
      2. Column-level Tracking
    3. Conflict Resolvers
      1. The Default Resolver
      2. Other Resolvers
      3. Custom Resolvers
      4. Business Logic Handlers
      5. Interactive Conflict Resolution
    4. Reviewing Conflicts
    5. Summary
  21. Chapter 13: Replication Monitor
    1. Starting Replication Monitor
    2. Removing a Publisher
    3. Connecting to a Publisher
    4. Viewing Information About a Publisher, Its Publications and Subscriptions
      1. Viewing Information About a Publisher
      2. Viewing Information About Transactional Publications
      3. Viewing Information About Merge Publications
      4. Viewing Information About Snapshot Publications
    5. Subscription Information
    6. Alerts
    7. Summary
  22. Chapter 14: Troubleshooting
    1. Troubleshooting the Publication
      1. The Log Reader Agent
      2. The Snapshot Agent
    2. Troubleshooting a Subscription
      1. But what About the PAL?
    3. Other Tools and Issues
      1. Tracer Tokens
      2. Always Check the Details
      3. Data Problems
    4. Summary