Accelerated Database Recovery in SQL Server 2025
June 19, 2025
Accelerated Database Recovery (ADR) was introduced in SQL Server 2019. Its main purpose is to allow for faster database recovery in the event of a crash or unexpected shutdown. Traditionally, the database engine handles crash recovery through a series of phases—analysis, redo, and undo—which can be inefficient and slow, especially when dealing with long-running transactions.
Audit Your Database Backup Chain!
October 30, 2023
All database administrators know that safeguarding data is paramount and having a strong restore strategy is crucial. In this post, I would like to add another tool to your arsenal that I have found helpful in auditing server health and configurations as it pertains to backups and the backup chain. A backup chain is important
Essential SQL Server Database Maintenance Tasks Every DBA Should Know
August 23, 2023
Database maintenance is a critical aspect of the DBA role, ensuring the smooth operation of SQL Server environments. Some folks will implement a SQL Server maintenance plan without fully digesting what they are doing, but we prefer you to do this with eyes wide open. In this post, we will explore key tasks and areas
SQL Server HA/DR Webinar
November 29, 2022
On Tuesday, 12/13/22, we presented a webinar about HA/DR (high availability and disaster recovery). Join Team Straight Path as we discuss what HA is, what DR is, and how they are different. We talked about the ways to achieve HA and DR. We’ll talk about the things we’ve learned about HA and DR along the