Introducing sp_CheckBackup: Check Your SQL Server Backups for Recoverability Issues

SQL Server database backup tool for checking recoverability issues

Whether you are backing up your SQL Server databases with Ola Hallengren’s scripts, Maintenance Plans, or some third-party software, your backups are your lifeline for recovering your data in case of a disaster. So…are your databases recoverable? Do you know WHERE your most recent backups were written? Do you know WHEN they were written? Did … Read more

SQL Server Health Check Worst Offenders

After performing hundreds of SQL Server Health Checks over the years, we wanted to share the most common repeat offenders we find time and again. These are: This topic is part of our monthly SQL Server webinar series. Webinar registrants get access to the entire recording, which includes the office hours Q&A. If you would … Read more

A Simple SQL Server Health Checklist

Being part of a consulting team has given me experience with many environments, and part of the work I do every week is to check for the various best practices and monitor server health across over 20 environments. This post condenses the tools that can help and the configurations that are most likely to cause … Read more