Backup & Recovery from First Principles, Part 1: Recovery Models Actually Explained

· by · in

Every SQL Server database has a recovery model, and most databases got theirs by inheritance rather than by decision: whatever model had at CREATE DATABASE time is what you are running today. That default determines…