none
What is expiry date in TDE certificates.

    Pertanyaan

  •  My certificate is expired but i can restore the database backup files on another SQL instance with expired certificates, what is the purpose of expiry date if I can restore database backup files with expired certificates on another SQL Instance. Can anyone brief me, what is expiry date in TDE? 

    Jumat, 06 Juli 2018 07.57

Jawaban

  • then what is the purpose of expiry date?
    I believe it is more to make sure you change certificate regularly. After old certificate is expired you can create a new certificate just in case someone copied this certificate or steals it , just like you change password. More details Here

    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Jumat, 06 Juli 2018 08.55

Semua Balasan

  •  My certificate is expired but i can restore the database backup files on another SQL instance with expired certificates, what is the purpose of expiry date if I can restore database backup files with expired certificates on another SQL Instance. Can anyone brief me, what is expiry date in TDE? 

    This is because its the Database encryption key which encrypts the data and it is stored at boot record, certificate is used to encrypt this DEK not the database. More details In This Blog

    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Jumat, 06 Juli 2018 08.06
  • then what is the purpose of expiry date?
    Jumat, 06 Juli 2018 08.16
  • then what is the purpose of expiry date?
    I believe it is more to make sure you change certificate regularly. After old certificate is expired you can create a new certificate just in case someone copied this certificate or steals it , just like you change password. More details Here

    Cheers,

    Shashank

    Please mark this reply as answer if it solved your issue or vote as helpful if it helped so that other forum members can benefit from it

    My TechNet Wiki Articles

    MVP

    Jumat, 06 Juli 2018 08.55