Warning: The certificate you created is expired.

  • we uses TDE Today I tryed to restore the TDE database on DR server with certificate but I found the below

    Warning: The certificate you created is expired.

    I have taken new certificate backup with new password then also why this worning is coming

    please suggest

    Regards,
    Shivrudra W

  • When you created the certificate, the expiry date you had given must have passed. One thing that can be done is Alter Symmetric key and drop the encryption that is using that certificate, Drop the certificate, then create a new certificate and then and encryption by using the new certificate.

    This is the only way I know. There might be other ways but I do not know any of them.

    make sure you test this in your test environment before you do this in prod.

    -Roy

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply