September 2010
Intermediate to advanced
1704 pages
111h 8m
English
In general, a couple of Microsoft SQL Server 2008 configuration options offer a very strong database engine foundation that can be highly available (7 days a week, 365 days a year). Microsoft’s sights are set on being able to achieve five-nines reliability with almost everything it builds. An internal breakthrough introduced with SQL Server 2005 called “copy-on-write” technology, has enabled Microsoft to greatly enhance several of its database high availability options.
Here are a few of the most significant enhancements and new features that have direct or indirect effects on increasing high availability for a SQL Server 2008–based implementation:
• Increased number of nodes in a SQL cluster—You can create a ...