SearchSQLServer.com SQL Server 2008 Fault Tolerance E-Guide

This document mainly introduces the new features of SQL Server 2008, including data protection and database fault tolerance.


SearchSQLServer.com SQL Server 2008 Fault Tolerance E-Guide - cover page
Brand
SearchSQLServer.com
Category
Other software
Document type
Other
Language
English
Pages
9
File format
PDF
File size
296 KB
Published
25 November, 2023
Updated
25 November, 2023
MD5 checksum
36CD829A33D3D68091199DEA055C7EC9

About this manual

This SearchSQLServer.com E-Guide, sponsored by Dell, explains how to manage the availability and fault tolerance of SQL Server 2008 installations. It covers failover clustering and database mirroring, then describes high availability options for SQL Server virtual machines.

The guide details single-site and multi-site failover clusters, database mirroring at the database level, and guest and host failover clustering for virtualized SQL Server. It also includes a Dell and Microsoft business intelligence advertisement.

What's inside

  • Creating fault-tolerant SQL Server installations
  • Maintaining high availability of SQL Server virtual machines
  • Creating fault-tolerant virtual installations
  • Resources from Dell Inc, Microsoft and AMD

Frequently asked questions

What is a single-site failover cluster in SQL Server?

It is a server configuration with up to 16 nodes linked to the same shared storage container, such as a SAN, iSCSI targets, or both.

Does database mirroring require special hardware or software?

No, database mirroring does not require any special hardware or software tools.

Is SQL Server 2008 supported on Hyper-V?

Yes, both SQL Server 2005 and 2008 are supported on Hyper-V and other non-Microsoft hardware virtualization technologies.

Why avoid host clustering when using database mirroring for a SQL Server VM?

A host cluster can restart the VM after a failure, which could cause two versions of the same database to be live on the network.

Download PDF (296 KB)