What's Coming in Yukon for High Availability?
In general, Yukon (Microsoft SQL Server 2005) is shifting very strongly to a goal of providing a database engine foundation that can be highly available seven days a week, 365 days a year. Microsoft's sights are set on being able to achieve five 9s with almost anything that is built within its four walls. We will list a few of the most significant enhancements and new features of Yukon later in this chapter. However, this author is only looking at beta software, and what actually ships in the final product build has yet to be determined.
Enhancements in Fail-over Clustering (SQL Clustering)
Still, the cornerstone of SQL Server fail-over is SQL clustering (or often termed SQL fail-over clustering