Pro SQL Server 2008 Replication

By Sujoy Paul

Pro SQL Server 2008 Replication Cover Image

Pro SQL Server 2008 Replication is for Microsoft database developers and administrators who want to learn about the different types of replication and those best suited to SQL Server 2008.

Full Description

  • ISBN13: 978-1-4302-1807-4
  • User Level: Intermediate to Advanced
  • Publication Date: June 21, 2009
  • Available eBook Formats: PDF
  • Print Book Price: $84.99
  • eBook Price: $59.99
Buy eBook Buy Print Book Add to Wishlist

Related Titles

Full Description

Pro SQL Server 2008 Replication is for Microsoft database developers and administrators who want to learn about the different types of replication and those best suited to SQL Server 2008. This book will also cover advanced topics like replication with heterogeneous databases, backup and recovery of replicated databases, database mirroring with replication, log shipping with replication, troubleshooting, plus optimization and tuning. Tools like tablediff, SQLCMD, DTA, SQL Profiler, and Replication Monitor will be discussed to demonstrate the different techniques used in monitoring, administering, and troubleshooting replication.

  • Examines the detailed configuration and the internal workings of the different replication types using real–life scenarios
  • Covers replication with database mirroring and troubleshooting
  • Discusses replication administration using different tools

What you’ll learn

  • Configure hierarchical replication: snapshot, transactional and merge, and heterogeneous replication using real–life scenarios.
  • Gain insight into the internal workings of the different replication types.
  • Master the usage of different tools like tablediff, SQLCMD, DTA, and Replication Monitor in administering replication.
  • Perform administration tasks such as backup and recovery, and manage replication with other high–availability techniques like database mirroring and log shipping.
  • Conduct optimization and tuning of replicated databases.
  • Develop troubleshooting techniques.
  • Set up a stand–alone Hadoop cluster the smart way, laid out simply and step by step so you can get up and running quickly to build your next data center, collaborative, data–intensive Internet services application, Software as a Service (SaaS), and more.

Table of Contents

Table of Contents

  1. Introduction
  2. Replication Basics
  3. Types of Replication
  4. Configuring Snapshot Replication Using the GUI
  5. Configuring Snapshot Replication Using T-SQL
  6. Snapshot Generation
  7. Internals of Snapshot Replication
  8. Configuring Transactional Replication Using the GUI
  9. Configuring Transactional Replication Using T-SQL
  10. Internals of Transactional Replication
  11. Configuring Merge Replication Using the GUI
  12. Web Synchronization with Merge Replication
  13. Configuring Merge Replication Using T-SQL
  14. The Internals of Merge Replication
  15. Backup and Recovery of Snapshot and Transactional Replication
  16. Backup and Recovery of Merge Replication
  17. Optimizing Snapshot Replication
  18. Optimizing Transactional Replication
  19. Optimizing Merge Replication
  20. Heterogeneous Replication
Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.

Errata

Please Login to submit errata.

No errata are currently published