[Description] The availability of SQL Server databases is improved by online indexing operations, fast recovery during crash recovery, and partial availability during restore operations, database page checksums, and backup media mirroring. Database mirroring enables the creation of hot standby servers providing rapid failover support with no loss of data from committed transactions. [Topic] 
Database Engine Availability Enhancements