This document mainly introduces the new features of SQL Server 2008, including data protection and database fault tolerance.
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.
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.
No, database mirroring does not require any special hardware or software tools.
Yes, both SQL Server 2005 and 2008 are supported on Hyper-V and other non-Microsoft hardware virtualization technologies.
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.