Backups

Test-DbaBackupEncrypted

Test-DbaBackupEncrypted View Source Chrissy LeMaire (@cl), netnerds.net Windows, Linux, macOS Synopsis Analyzes backup files to determine encryption status and retrieve encryption details Description Examines SQL Server backup files to identify whether they contain encrypted data, either through backup encryption or Transparent Data Encryption (TDE). Uses RESTORE HEADERONLY and RESTORE FILELISTONLY commands to inspect backup headers and file metadata without actually restoring the database. This helps DBAs verify encryption compliance, troubleshoot restore issues, and maintain inventory of encrypted backups across their environment.