Can a database with an InMemory File Group be encrypted with TDE?

Sylvia Rivera 21 Reputation points
2021-01-29T19:18:26.137+00:00

Can an SQL database with an InMemory File Group be encrypted with TDE?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,150 questions
0 comments No comments
{count} votes

Accepted answer
  1. David Browne - msft 3,851 Reputation points
    2021-01-29T20:00:54.497+00:00

    From the docs:

    TDE and In-Memory OLTP

    You can enable TDE on a database that has In-Memory OLTP objects. In SQL Server 2016 (13.x) and Azure SQL Database, In-Memory OLTP log records and data are encrypted if you enable TDE. In SQL Server 2014 (12.x), In-Memory OLTP log records are encrypted if you enable TDE, but files in the MEMORY_OPTIMIZED_DATA filegroup are unencrypted.

    https://learn.microsoft.com/en-us/sql/relational-databases/security/encryption/transparent-data-encryption?view=sql-server-ver15#tde-and-in-memory-oltp

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.