[Script Of Oct. 22] How to check SQL Server encryption certificates present without a backup issue

image

Oct.

22

image

image

Script Download:   
The script is available for download from https://gallery.technet.microsoft.com//How-to-check-SQL-Server-ad328a54.  You can also use  Microsoft Script Browser for Windows PowerShell ISE to download the sample with one button click from within your scripting environment.

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.

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