Licensing Considerations for High-Availability Environments

High availability with SQL Server 2005 involves configuring two or more servers so that if one of them fails, one of the others can pick up the workload and continue processing. SQL Server 2005 offers three types of solutions for achieving high-availability: failoverclustering, database mirroring, and backup log shipping, all of which are explained in detail in Chapter 26, and Chapter 28. Each of these solutions uses one or more standby or "passive" servers, which hold a replica of the main "active" database. During normal processing, the workload is directed to the "active" server, as shown in Figure 2-4. In the event of a failure of the "active" server, the processing is transferred ...

Get Microsoft® SQL Server™ 2005 Administrator's Companion now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.