[Script of May 2] Check SQL Server encryption certificates present without a backup issue(VBS)

  • Article

Script Download:CheckEncryptionCertificates.zip
https://gallery.technet.microsoft.com/scriptcenter/Check-SQL-Server-4feff69f/

This script can be used to check your SQL Server encryption certificates without backup issue.

This script can be used to identify the certificates used in TDE (Transparent Data Encryption) which have not been backed up and then list the affected databases.

image image
image

You can find more All-In-One Script Framework script samples at https://aka.ms/onescriptingallery