TDE Decryption Timer Script

  • SQLShark

    SSCrazy

    Points: 2196

    Comments posted to this topic are about the item TDE Decryption Timer Script

  • Eric M Russell

    SSC Guru

    Points: 125018

    There may be a reason why you're wanting to wait for encryption to fully complete before moving to the next step, but I'd just like to bring up fact that encryption process is asynchronous and non-blocking, so users may still read and write to database in the interim.

    "Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho

  • SQLShark

    SSCrazy

    Points: 2196

    Yes there is, no users have access to the Sanitize server and data where this is being performed. We have automated a Sanitization or data masking process where the copy of a TDE encrypted database is to be moved to a Sanitize server and have the confidential data masked from the production environment on a "Sanitize\Masking" server for moving to a development environment. The timer helps avoid an error for the final masked backup to the "Sanitized" directory. File is then moved to development from there for testing purposes.

  • sak3438

    SSC Enthusiast

    Points: 110

    Great Script

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

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