Microsoft® SQL ServerTM 2000 High Availability.

Format:

Book

Author/Creator:

Hirt, Allan.

Contributor:

Cook, Cathan.

Tripp, Kimberly.

McBath, Frank.

Language:

English

Subjects (All):

Client/server computing.

Relational databases.

SQL server.

Local Subjects:

Client/server computing.

Relational databases.

SQL server.

Physical Description:

1 online resource (0 p.)

Edition:

1st edition

Place of Publication:

Sebastopol : Microsoft Press, 2009.

Language Note:

English

System Details:

text file

Summary:

Get the definitive reference to maximizing the availability of your critical, SQL Server 2000-based business systems. Developed by Microsoft field consultants who create and support high availability solutions every day, this practical guide explains how to plan, design, implement, and support highly available SQL Server 2000-based systems for both 32-bit and 64-bit environments. You get in-depth, end-to-end guidance-from evaluating availability requirements and capacity planning to implementing failover clustering, log shipping, replication, system backup and restore, system recovery,

Contents:

Microsoft® SQL ServerTM 2000 High Availability; Preface; Acknowledgments; Cathan Cook; Frank McBath; Kimberly L. Tripp; I. The High Availability Primer; Disaster Recovery; Agreeing on a Solution; Guiding Principles for High Availability; Making Trade-Offs; Identifying Risks; Next Steps; Availability Calculations and Nines; What Is a Nine?; What Level of Nines Is Needed?; Negotiating Availability; Types of Unavailability; Where Does Availability Start?; The Cost of Availability; Barriers to Availability; Summary; 2. The Basics of Achieving High Availability; Security

Cabling, Power, Communications Systems, and NetworksThird-Party Hosting; Support Agreements; The ""Under the Desk"" Syndrome; Staffing; Service Level Agreements; Manage Change or Be Managed by It; Development, Testing, and Staging Environments; Managing Change and Availability in Development; Version Control; Testing Applications for High Availability; Managing Change in Production; Preparing for Change; Contingency Plans; Implementation Team; Determining an Implementation Window; Planning the Implementation, Twice; Testing the Implementation; Release Readiness Review

Completing a Change Request FormImplementing Change; Step 2: Back Up, Back Up, Back Up; Step 3: The Rollout; Step 4: When It Is All Over; System and Process Standardization; Documentation; Summary; 3. Making a High Availability Technology Choice; Cluster Concepts; Network Load Balancing Clusters; Geographically Dispersed Clusters; SQL Server 2000; How SQL Server Failover Clustering Works; Clients and SQL Server 2000 Failover Clustering; Failover Clustering and Wasted Resources; Log Shipping; Clients and Log Shipping; Replication; Clients and Replication; Backup and Restore

Decisions, Decisions ...Step 2: Comparing Technologies; Step 3: Selecting Technology; A Comparison of the SQL Server Technologies; Choosing Between Failover Clustering and Log Shipping or Replication; Using the SQL Server Availability Technology Comparison Table; What Should You Use?; Summary; II. Technology Building Blocks; Capacity Planning; Application Database Usage; Indexes; Deletes, Inserts, Selects, and Updates; Understanding Physical Disk Performance; Using SQL Server to Assist with Disk Capacity Planning; Types of Disk Subsystems; Network-Attached Storage

Using Network-Attached Storage as a Data Store with SQL ServerStorage Area Networks; What Disk Technology to Use; Server Clusters, Failover Clustering, and Disks; Pre-Windows Disk Configuration; Step 2-Individual Drive Throughput; Step 3-Calculating Number of Spindles; Understanding Disk Drives; Understanding Your Hardware; Understanding How SQL Server Interacts with Disks; Understanding Disk Cache; A RAID Primer; Mirroring; Striped Mirrors; Mirrored Stripes; Striping with Parity; Hardware RAID versus Software RAID; Remote Mirroring; Storage Composition

Types of Disks and File Systems in Windows

Notes:

Description based upon print version of record.

ISBN:

9780735635845

0735635846

OCLC:

609857080