Relevance of Microsoft SQL Server
2008 High Availability
What is High Availability?
This section introduces
several SQL Server
high-availability solutions
that improve the
availability of servers or
databases. A
high-availability solution
masks the effects of a
hardware or software failure
and maintains the
availability of applications
so that the perceived
downtime for users is
minimized
Features
of High Availability
Recover corrupt data pages
from a mirror server with
enhanced database mirroring
features
Take advantage of failover
clustering enhancements in
Microsoft SQL Server 2008
and Microsoft Windows Server
2008
Add new nodes to a
peer-to-peer replication
solution without taking
applications offline
Improve restore times and
reduce backup volume size
with new support for backup
compression
Improve concurrency with
locking enhancements
Reduce downtime for hardware
maintenance with Hot-Add CPU
capabilities
Use Resource Governor to
proactively control workload
prioritization
