For many businesses, database performance and availability are crucial elements. A database crash or a lengthy transaction can cause a lot of downtime and have a negative effect on business operations. However, with the introduction of Accelerated Database Recovery (ADR), Microsoft SQL Server has added a potent new feature that greatly enhances database availability and performance. In this post, we’ll explore how ADR works and its benefits for SQL Server users.
Let’s first take a look at the traditional SQL Server database recovery process before moving on to ADR. The SQL Server engine uses a three-phase process to restore a database