Backup & Recovery from First Principles, Part 4: Copy-Only Backups, the Chain-Safe Snapshot
ended with a rule: one tool owns log backups, and everything else takes COPY_ONLY. This part explains what copy-only backups actually change, proves it from msdb, and then builds the pattern that makes them genuinely…
Backup & Recovery from First Principles, Part 3: The Log Chain and How People Break It
showed that log backups form a linked list: each backup’s first_lsn equals the previous backup’s last_lsn. Point-in-time restore works by walking that list. Break one link and every log backup after the break is useless…
Backup & Recovery from First Principles, Part 2: Anatomy of a Backup
A backup file is not a copy of your MDF. It is a container with a precise contract: enough pages and enough log to reconstruct a transactionally consistent database as of the moment the backup…
Backup & Recovery from First Principles, Part 1: Recovery Models Actually Explained
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…
Self-Hosting Forgejo on Windows Server Hyper-V Step-by-Step
A complete walkthrough for running Forgejo on Debian 13 inside a Windows Server Hyper-V VM, with Docker Compose, Let’s Encrypt TLS, GitHub repo mirroring, and automated backups to a Windows network share.
Building a Backup Automation Framework with AI
Build a real backup automation framework in PowerShell with AI multi-instance, retention, verification, and dbatools.