0

I would like to know that How SQL database backup and its restoration on other server will work if Always Encrypted feature is implemented on most of its tables?

Thanks

  • Hey @Sunny What version of SQL Server are you using? – Anthony Genovese Jul 18 '19 at 14:14
0

I tested with "Window Certificate Store - Current User" and "Windows Certificate Store - Local machine (localhost) and concluded to.

Existence of any object related to Always Encrypted features (master key, column master key and the certificates used to create the master key) is limited to the database only.

So simple backup and restore process works fine.

Thanks!

| improve this answer | |
  • Hi Rajesh, Thanks for the response! Is there anything extra need to perform on Always Encrypted database if i am restoring a .bak file to another server or will it normally work without doing anything in addition? Thanks! – Sunny Jul 19 '19 at 11:43
  • Transparent Data Encryption (TDE) and Always Encrypted (AE) are 2 different features of SQL Server. TDE helps you in entire database security whereas AE helps you to secure sensitive data with a database. If you use TDE then yes you need to restore/create master key and certificates on target server before DB restore but not in case of AE. – Rajesh Ranjan Jul 19 '19 at 11:55

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.