Back to the list Mastering SQL Server · Trunk Road

Lesson 5/6 Encrypted SQL backups: your data stays out of reach

Name: Encrypted SQL backups: your data stays out of reach
Uploaded: 2026-03-03
Description: Encrypt your SQL backups so they stay useless to anyone who steals them.

Encrypting SQL Server backups with a certificate and a master key. Creating the master key and the certificate. An encrypted full backup. Exporting the certificate and importing it on another server. A full demonstration of a secure restore. Without the certificate, no restore is possible.