Microsoft SQL Server 2008 High Availability


Microsoft SQL Server 2008 High Availability
eBook: $29.99
Formats: PDF, PacktLib, ePub and Mobi formats
$25.49
save 15%!
Print + free eBook + free PacktLib access to the book: $79.98    Print cover: $49.99
$49.99
save 37%!
Free Shipping!
UK, US, Europe and selected countries in Asia.
Also available on:
Overview
Table of Contents
Author
Support
Sample Chapters
  •  Install various SQL Server High Availability options in a step-by-step manner
  •  A guide to SQL Server High Availability for DBA aspirants, proficient developers and system administrators
  •  Learn the pre and post installation concepts and common issues you come across while working on SQL Server High Availability
  •  Tips to enhance performance with SQL Server High Availability
  •  External references for further study

 

Book Details

Language : English
Paperback : 308 pages [ 235mm x 191mm ]
Release Date : January 2011
ISBN : 1849681228
ISBN 13 : 9781849681223
Author(s) : Hemantgiri S. Goswami
Topics and Technologies : All Books, Enterprise Products and Platforms, Microsoft Servers, Enterprise, Microsoft, Microsoft SQL Server

Table of Contents

Preface
Chapter 1: Understanding Windows Domains, Domain Users, and SQL Server Security
Chapter 2: Implementing Clustering
Chapter 3: Snapshot Replication
Chapter 4: Transactional Replication
Chapter 5: Merge Replication
Chapter 6: Peer-to-Peer Replication
Chapter 7: Log Shipping
Chapter 8: Database Mirroring
Appendix A: Troubleshooting
Appendix B: External References
Index
  • Chapter 1: Understanding Windows Domains, Domain Users, and SQL Server Security
    • Windows domains and domain users
    • Understanding SQL Server Security
      • Windows authentication
    • What is clustering?
    • How clustering works
    • MSDTC
    • Types of clusters
      • Single-instance Cluster
      • Multi-instance Cluster
      • Multi-site Failover Cluster
      • Guest Failover Clustering
    • Components of clustering
      • Shared disk array
    • The Quorum
    • Public and Private Network
    • Summary
    • Chapter 2: Implementing Clustering
      • What is Hyper-V?
      • Installation prerequisites for SQL Server 2008 R2
        • Hardware requirements
        • Software requirements
        • Operating system requirements
        • Server role and feature
        • IP addresses
        • Network name
        • Shared disks
      • Installing a Single-instance Failover Cluster
        • Adding a node to an SQL Server failover cluster
      • Installing the SQL Server failover cluster using the command prompt
      • Installing SQL Server failover cluster using the Configuration file
      • Installing Multi-instance (Active/Active) Failover Cluster
        • Adding a node to a SQL Server failover cluster
      • Configuration
        • Write caching
        • File shares
        • Maximum memory size
        • Minimum memory size
        • Preferred owners
        • LooksAlive
        • IsAlive
        • Restart
        • Affect the Group
        • Dependencies
        • File share
      • Anti Virus tool
      • Summary
      • Chapter 3: Snapshot Replication
        • Components of the replication
        • Types of replication
          • Snapshot Replication
          • Transactional Replication
          • Merge Replication
          • Peer-to-Peer Replication
        • Replication topologies
        • How replication works
        • Prerequisites for Snapshot Replication
        • Installing
          • Configuring Distributor and Publisher
          • Creating publication
          • Creating subscription
        • Configuring Snapshot Replication
        • Snapshot Agent
        • Distribution Agent
        • Maintenance jobs
          • Agent history clean up: distribution
          • Distribution clean up: distribution
          • Expired subscription clean up
          • Reinitialize subscriptions having data validation failures
          • Replication agents check-up
          • Replication monitoring refresher for distribution
        • Configuring publication properties
          • Configuring alerts
          • Snapshot Agent parameters
          • Adding and dropping an article and a column to the existing publication using T-SQL
        • Summary
        • Chapter 4: Transactional Replication
          • Prerequisites for Transactional Replication
            • Working with Transactional Replication
          • Installing Transactional Replication
            • Creating new publication for Transactional Replication
            • Creating subscription for Transactional Replication
          • Installing publication and subscription using T-SQL
          • Configuring Transactional Replication
            • Parameters to be configured with Distribution Agent profile
          • Summary
          • Chapter 5: Merge Replication
            • Merge Replication usages
            • How Merge Replication works
            • Prerequisites for Merge Replication
            • Installing Merge Replication
              • Creating publication
              • Creating subscription
            • Configuration
              • Configuring publication using T-SQL
              • Configuring the Subscriber using T-SQL
              • Creating alternate synchronization partner using T-SQL
              • Dropping an alternate synchronization partner using T-SQL
              • Uninstalling subscription
              • Configuring download-only articles
              • Configuring alerts using SSMS
            • Summary
            • Chapter 6: Peer-to-Peer Replication
              • What is Peer-to-Peer Replication?
              • How Peer-to-Peer Replication works
              • Prerequisites for Peer-to-Peer Replication
              • Installing Peer-to-Peer Replication
              • Configuration
                • Configuring alerts
                • Removing a node from Peer-to-Peer Replication
              • Adding SQL Server 2005 as a Peer-to-Peer node
              • Summary
              • Chapter 7: Log Shipping
                • What is Log Shipping?
                • How Log Shipping works
                • Prerequisites for Log Shipping
                  • Installing Primary Server
                  • Setting up the secondary database
                • Setting Monitor Server instance
                • Configuration
                  • Setting up Primary Server for Log Shipping
                  • Setting up Secondary Server
                • Summary
                • Chapter 8: Database Mirroring
                  • What is Database Mirroring
                  • Different components of the Database Mirroring
                  • How Database Mirroring works
                    • Asynchronous a.k.a. High Performance mode
                    • Synchronous a.k.a. High Safety mode
                  • Prerequisites
                  • Installing Database Mirroring
                    • Preparing for Database Mirroring
                    • Installing Database Mirroring
                    • Starting Database Mirroring
                    • Manual or forced failover
                    • Adding the Witness Server
                  • Configuration using T-SQL
                    • Monitoring the Database Mirroring status using Database Mirroring Monitor
                    • Configuring the threshold for Database Mirroring
                  • Summary
                  • Appendix A: Troubleshooting
                    • Chapter 2: Implementing Clustering
                      • Common troubleshooting—installation
                        • Network binding order
                        • Problem while adding a second node
                      • Common troubleshooting and tips—resources
                    • Chapter 3: Snapshot Replication
                      • Troubleshooting using Replication Monitor (RM)
                    • Chapter 4: Transactional Replication
                    • Chapter 5: Merge Replication
                      • Index on columns used in filters
                      • LOB data types
                      • Avoid using identity column as primary key
                      • Frequently asked questions
                    • Chapter 6: Peer-to-Peer Replication
                    • Chapter 7: Log Shipping
                      • Frequently asked questions
                    • Chapter 8: Database Mirroring
                    • Appendix B: External References
                      • Chapter 1: Understanding Windows Domain, Domain Users, and SQL Server Security
                      • Chapter 2: Implementing Clustering
                      • Chapter 3: Snapshot Replication
                      • Chapter 4: Transactional Replication
                      • Chapter 5: Merge Replication
                      • Chapter 6: Peer-to-Peer Replication
                      • Chapter 7: Log Shipping
                      • Chapter 8: Database Mirroring

                      Hemantgiri S. Goswami

                      Hemantgiri S. Goswami is a SQL Server consultant based in Surat, India. He has been a Microsoft SQL Server MVP three years running; he also moderates multiple SQL Server community forums including http://www.sql-server-performance.com and http://www.sqlserver-qa.net. He actively participates and speaks at local user group events organized under the aegis of http://www.surat-user-group.org, DotNetChaps and CSI Surat chapters, of which he is a founding and active member. He regularly publishes article on his blog space http://www.sql-server-citation.com. He has recently taken up a new initiative - blogging about SQL in his native language Gujarat through his blog http://sqlservercitation-gujarati.blogspot.com

                      He has more than 11 years of experience in the IT industry, of which nine years have been as a hard core DBA focusing on High Availability area. During his career, he has worked with the top five IT giants of India. In addition to SQL Server, Hemantgiri also possesses excellent knowledge of Windows Server OS(s) and Networking.

                      In his free time, he prefers to watch cartoons, read and sometimes sketches.

                      You can reach him via his blog – http://www.sql-server-citation.com , twitter – http://www.twitter.com/ghemant or by writing to him at Hemantgiri [at] sql-server-citation.com

                      Sorry, we don't have any reviews for this title yet.

                      Code Downloads

                      Download the code and support files for this book.


                      Submit Errata

                      Please let us know if you have found any errors not listed on this list by completing our errata submission form. Our editors will check them and add them to this list. Thank you.

                      Sample chapters

                      You can view our sample chapters and prefaces of this title on PacktLib or download sample chapters in PDF format.

                      Frequently bought together

                      Microsoft SQL Server 2008 High Availability +    Microsoft SQL Server 2008 R2 Administration Cookbook =
                      50% Off
                      the second eBook
                      Price for both: ₨388.00

                      Buy both these recommended eBooks together and get 50% off the cheapest eBook.

                      What you will learn from this book

                      • Learn about the prerequisites for installing SQL Server HA
                      • Understand the windows domain and various handshake methods
                      • Understand SQL Server's authentication mechanism and SQL Server security
                      • Configure and manage database mirroring for high availability
                      • Handle cluster management and backup
                      • Use log shipping to provide database-level redundancy by automatically backing up, copying, and restoring transaction logs on servers
                      • Increase scalability, availability, and processing capacity by configuring applications to use peer-to-peer replication
                      • Monitor the performance of SQL Server HA
                      • Explore the concepts of SQL Server clustering, different types of SQL cluster

                       

                      In Detail

                      Every business has it's mission critical applications and data. Therefore, it is very important to keep database servers up and running all the time – 24 X 7. There is a need to store and process terabytes of data to cater for business needs, and it is vital to make data highly available.

                      High availability is all about the site being accessible all the time. High availability solutions minimize the downtime for these mission critical applications.

                      Microsoft SQL Server is a powerful relational database engine, widely used to store and maintain data in Enterprises of various levels be they small, medium or large.

                      This book will teach you how best to use these readily-available options and save you time in making your websites highly available.

                      This Microsoft SQL Server 2008 High Availability book will take you through pre and post installation concepts and common issues you come across while working with SQL Server HA. It will teach you how these various HA solutions can be installed using GUI and the command line. It will also show you how to troubleshoot common issues you may encounter whilst installing or managing the HA option in your environment. It provides references to external links for more advanced learning on the topic.

                      This book starts with an introductory chapter into the windows domain, domain users and various handshake methods available with Windows server. It also offers information the different authentication methods available with SQL Server - giving you an insight into the importance of security. After you are through with the security aspects, your journey to installing SQL Server HA will start. It will cover the concepts of database mirroring, log shipping, clustering, and replication.

                      By the end of this book you will be confident enough to take up the challenge to install any of the SQL Server HA options.

                      A step-by-step guide to SQL Server HA for DBA aspirants, proficient developers and system administrators

                      Approach

                      With clear step-by-step instructions, various real world examples, and plenty of screenshots, this book provides all the support and guidance you will need as you begin to install various SQL Server HA options.

                      Who this book is for

                      If you are an SQL Server developer, or a system administrator, or even a novice DBA, then this book is for you.

                      It only requires you to have a basic understanding of how SQL Server works to get you through the installation of SQL Server HA.

                      Code Download and Errata
                      Packt Anytime, Anywhere
                      Register Books
                      Print Upgrades
                      eBook Downloads
                      Video Support
                      Contact Us
                      Awards Voting Nominations Previous Winners
                      Judges Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software
                      Resources
                      Open Source CMS Hall Of Fame CMS Most Promising Open Source Project Open Source E-Commerce Applications Open Source JavaScript Library Open Source Graphics Software