I am using SQL 2014 standard and am using the native backup encryption by using a certificate. I noticed the other day that my backup encryption certificate is going to expire soon. Does anyone know how to extend the expiration date of the certificate? I know I can drop the certificate and create a new one (this time I will set the expiration date to something other than the default one year). But I was hoping to extend the expiration of my current certificate so that the thumbprint will not change and I would not have to carry around two certificates? I have backups of the certificate and tried doing this but I am not sure I can include EXPIRY_DATE when restoring a cert, I am getting a syntax error? DROP Certificate Testcert2; CREATE CERTIFICATE Testcert2 FROM FILE ='C:\TEMP\test\Testcert2.cert' WITH PRIVATE KEY(FILE='C:\TEMP\test\Testcert2.key', DECRYPTION BY PASSWORD='Test123!@#'), EXPIRY_DATE = '20201030'