Pro SQL Server 2008 Replication

1. Front Matter

   Pages i-xxiv

   PDF

2. Introduction

   Pages 1-16

3. Replication Basics

   Pages 17-55

4. Types of Replication

   Pages 57-83

5. Configuring Snapshot Replication Using the GUI

   Pages 85-122

6. Configuring Snapshot Replication Using T-SQL

   Pages 123-150

7. Snapshot Generation

   Pages 151-168

8. Internals of Snapshot Replication

   Pages 169-221

9. Configuring Transactional Replication Using the GUI

   Pages 223-260

10. Configuring Transactional Replication Using T-SQL

    Pages 261-314

11. Internals of Transactional Replication

    Pages 315-398

12. Configuring Merge Replication Using the GUI

    Pages 399-441

13. Web Synchronization with Merge Replication

    Pages 443-470

14. Configuring Merge Replication Using T-SQL

    Pages 471-536

15. The Internals of Merge Replication

    Pages 537-598

16. Backup and Recovery of Snapshot and Transactional Replication

    Pages 599-652

17. Backup and Recovery of Merge Replication

    Pages 653-695

18. Optimizing Snapshot Replication

    Pages 697-736

19. Optimizing Transactional Replication

    Pages 737-800

20. Optimizing Merge Replication

    Pages 801-835

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

• Databases
• Microsoft SQL Server
• SQL
• SQL Server 2008
• Transact-SQL
• database
• database administration

Sujoy Paul is a results-oriented database and software professional with extensive experience in different relational database management systems like MS SQL Server 2000, Sybase ASA, and Sybase ASE, data modeling, case-based tools like PowerDesigner, and coding and testing in demanding hi-tech environments. Sujoy's background includes expertise in database replication, with special interest in two-way replication, backup and recovery, performance and tuning, and troubleshooting. Sujoy has a demonstrated ability to provide training for replication and Microsoft certifications on design and administration of SQL Server 2000. Sujoy is a Microsoft Certified Professional (installing, configuring, and administering Microsoft SQL Server 2000 Enterprise Edition). He is the author or coauthor of dozens of technical papers, including ""Replicating SQL Server 2000 across Heterogeneous Databases"" (SQLTeam.com, August 2003).

Policies and ethics