Chapter 19. Replication

After completing this chapter, you will be able to

  • Understand the different types of replication.

  • Understand the different replication agents.

  • Configure and monitor replication.

Moving data from one server to another or from one data center to another is something you will frequently do when working with enterprise data. The specific reasons vary, but typically there is a need to have a secondary copy for reporting, backup, and possibly disaster recovery. Regardless of the reason for moving the data, a viable solution should be available that will allow a seamless and consistent procedure.

Replication is a group of Microsoft SQL Server 2012 technologies that you can use to copy and move data and database objects from one database ...

Get Microsoft® SQL Server® 2012 Step by Step now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.