Databases on Azure Managed Instance
are encrypted by default. And these dbs have Service-managed Transparent data encryption (TDE). One of our database is a restored database from a .bak
file, and hence its Encryption Enable
property was set to False
. We want this database to be encrypted, as well. Question: Can we enable this database just by setting Encryption Enable
to True. Will it cause any issues. Are there any other steps that need performed for encrypting this database. We heard you have to create Master Key etc. But for our all other databases, that have Service-managed Transparent data encryption (TDE), we don't see any master key.
1 Answer
just do this:
ALTER DATABASE mydb
SET ENCRYPTION ON;
GO