Pro SQL Server 2008 Replication, 2/e (Paperback)

Sujoy Paul

  • 出版商: Apress
  • 出版日期: 2009-06-17
  • 售價: $4,080
  • 貴賓價: 9.5$3,876
  • 語言: 英文
  • 頁數: 936
  • 裝訂: Paperback
  • ISBN: 143021807X
  • ISBN-13: 9781430218074
  • 相關分類: MSSQLSQL
  • 海外代購書籍(需單獨結帳)

買這商品的人也買了...

商品描述

Pro SQL Server 2008 Replication is for MS 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.

Who is this book for?

This book is a comprehensive guide for experienced users of SQL Server as well as new users. It also aims at familiarizing the current users of SQL Server 2005 with the new features of replication should they upgrade to SQL Server 2008. This book will delve into the basics of replication like the publisher–subscriber model, the different replication types (such as snapshot, transactional, merge, and heterogeneous), the corresponding architecture, implementation, and administration. Database administration tasks like backup and recovery, managing replication with high–availability techniques like database mirroring, log shipping with replication, and optimization of replicated databases will also be discussed. This book will benefit primarily novice and intermediate users by introducing replication and the different processes and then building on the basics to develop and address the advanced features of replication. This is a must–have companion book that will help you in developing, administering and mastering the intricacies of replication.

About the Apress Pro Series

The Apress Pro series books are practical, professional tutorials to keep you on and moving up the professional ladder.

You have gotten the job, now you need to hone your skills in these tough competitive times. The Apress Pro series expands your skills and expertise in exactly the areas you need. Master the content of a Pro book, and you will always be able to get the job done in a professional development project. Written by experts in their field, Pro series books from Apress give you the hard–won solutions to problems you will face in your professional programming career.

商品描述(中文翻譯)

《Pro SQL Server 2008 Replication》適用於想要了解不同類型的複寫以及適用於SQL Server 2008的MS資料庫開發人員和管理員。本書還將涵蓋高級主題,如異構資料庫的複寫、複寫資料庫的備份和恢復、複寫的資料庫鏡像、複寫的日誌傳送、故障排除,以及優化和調整。將討論像tablediff、SQLCMD、DTA、SQL Profiler和Replication Monitor這樣的工具,以演示監控、管理和故障排除複寫所使用的不同技術。


  • 通過實際情境檢查不同複寫類型的詳細配置和內部運作

  • 涵蓋與資料庫鏡像和故障排除相關的複寫

  • 討論使用不同工具進行複寫管理

你將學到什麼



  • 配置階層式複寫:快照、事務性和合併,以及使用實際情境的異構複寫

  • 深入了解不同複寫類型的內部運作

  • 掌握使用tablediff、SQLCMD、DTA和Replication Monitor等不同工具在複寫管理中的應用

  • 執行備份和恢復等管理任務,並使用資料庫鏡像和日誌傳送等其他高可用性技術管理複寫

  • 進行優化和調整複寫資料庫

  • 發展故障排除技巧

這本書適合誰閱讀?


本書是一本全面指南,適用於有經驗的SQL Server使用者以及新使用者。它還旨在讓SQL Server 2005的現有使用者熟悉複寫的新功能,以便升級到SQL Server 2008。本書將深入探討複寫的基礎知識,如發布者-訂閱者模型、不同的複寫類型(如快照、事務性、合併和異構)、相應的架構、實施和管理。還將討論資料庫管理任務,如備份和恢復,以及使用資料庫鏡像、複寫的日誌傳送和優化複寫資料庫。本書主要對初學者和中級使用者有益,介紹複寫和不同的過程,然後在基礎上發展和解決複寫的高級功能。這是一本必備的伴侶書,將幫助您開發、管理和掌握複寫的細節。

關於Apress Pro系列


Apress Pro系列書籍是實用的專業教程,可幫助您在職業生涯中不斷提升。


您已經得到了工作,現在您需要在這個競爭激烈的時代中磨練自己的技能。Apress Pro系列擴展了您在所需領域的技能和專業知識。掌握Pro系列書籍的內容,您將始終能夠在專業開發項目中完成工作。Apress Pro系列書籍由各自領域的專家撰寫,為您提供在職業程式設計生涯中將面臨的問題的寶貴解決方案。