Change Certificate Expiration

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'
more ▼

asked Oct 23, 2015 at 04:02 PM in Default

avatar image

130 1 1 6

Everything that I've read in the MSDN documentation states that the expiration data is not checked when it's used for encryption. However, I don't know if that also applies to backup encryption. It appears that you can't create a certificate with a past expiration date to test.

Look under "Expiry_Date": https://msdn.microsoft.com/en-us/library/ms187798.aspx

Oct 23, 2015 at 04:38 PM JohnM

Backup encryption the expiration date takes effect because I had an expired certificate on a dev server and was able to test. It will not allow any backups once the expiration date is reached.

Oct 23, 2015 at 05:03 PM DBANovice

Well, that blows that theory out of the water. ;-) Sorry that didn't help at least give you a breather.

Oct 23, 2015 at 05:13 PM JohnM

Thanks for the help, I just created a new cert and stored the old backup cert file in a safe location.

Oct 23, 2015 at 08:29 PM DBANovice
(comments are locked)
10|1200 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Oct 23, 2015 at 04:02 PM

Seen: 1085 times

Last Updated: Oct 23, 2015 at 08:29 PM

Copyright 2016 Redgate Software. Privacy Policy