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?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
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.