Red Gate recently released Fundamentals of SQL Server 2012 Replication authored by Dr. Sebastian Meine and it contains 14 chapters. While chapter 1 provides an overview of SQL Server Replication, Chapter 2 examines the steps required to configure basic replication setup such as setting up the distributor, publication and subscription.
Chapter 3 examines the role of the distributor including the best practices to be followed. Chapters 4 & 5 provide an overview of replication agents and transactional replication related to publication. The author examines the steps related to configure publication access list in chapter 6.
You will learn transactional replication aspects related to subscription in addition to configuration of retention. The next chapter covers SQL Server agent jobs such as snapshot, log reader, distribution and replication maintenance in addition to the coverage of the steps related to create SQL Server agent jobs.
Chapters 9, 10 and 11 examine merge replication aspects related to replication agents, publication, subscription and conflicts. Chapter 13 provides coverage of the usage of replication monitor. Among other concepts you will learn the steps required to view information about a publisher, transactional publications, merge and snapshot publications.
The author has provided detailed step-by-step explanation along with relevant screenshots in addition to diagrams, screenshots and source codes. In the final chapter, you will learn the steps related to troubleshoot publication, subscription including coverage of tracer tokens and date problems.
Fundamentals of SQL Server 2012 Replication will be useful for database administrators, SQL Server trainers and for those developers who would like to explore advanced techniques associated with SQL Server.
Fundamentals of SQL Server 2012 Replication
Paperback: 376 pages
Publisher: Red gate books
Release Date: August 27, 2013