万本电子书0元读

万本电子书0元读

顶部广告

Microsoft SQL Server 2008 High Availability电子书

售       价:¥

67人正在读 | 0人评论 9.8

作       者:Hemantgiri S. Goswami

出  版  社:Packt Publishing

出版时间:2011-01-24

字       数:99.1万

所属分类: 进口书 > 外文原版书 > 电脑/网络

温馨提示:此类商品不支持退换货,不支持下载打印

为你推荐

  • 读书简介
  • 目录
  • 累计评论(0条)
  • 读书简介
  • 目录
  • 累计评论(0条)
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. 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.
目录展开

Microsoft SQL Server 2008 High Availability

Table of Contents

Microsoft SQL Server 2008 High Availability

Credits

Foreword

About the Author

Acknowledgement

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers and more

Why Subscribe?

Free Access for Packt account holders

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Errata

Piracy

Questions

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

Internet Small Computer System Interface

Storage Area Network (SAN)

Redundant Array of Independent Disks

The Quorum

Public and Private Network

Summary

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

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

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

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

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

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

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

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

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

Index

累计评论(0条) 0个书友正在讨论这本书 发表评论

发表评论

发表评论,分享你的想法吧!

买过这本书的人还买过

读了这本书的人还在读

回顶部