In this follow-up, I show how we determine all possible point of time restores and identify which backup files to keep in order to meet our recovery objectives.
2025
In this article, I detail some of the things we do to manage backups and retention policies for hundreds of production databases.
I put together a brief list of all the things that can cause "A network-related or instance-specific" error messages, and a few things that can't.
As the SQL Server 2025 public preview hit the streets, I had to test the new backup compression algorithn, ZSTD, on a decently-sized database.
Occasionally, it's fun to talk about our wish lists for SQL Server. In this post, I talk about a few that I came across recently…