SQL Server 2012 and Encrypting multiple Databases to turn TDE ON?

Question

Since we have already encrypted the SQL Server to now be able to enable TDE on each database I need to know what else I need to do at this point to Alter about 80 SQL Databases to turn TDE ON each one.

Note that 4 SQL Databases have it turned on and was done manually by simply running the statement below

ALTER DATABASE SampleDB SET ENCRYPTION ON

Just trying to validate that I can just create a line by line for each one and let it go and then check it with the statement I created below that validates that they are now have TDE ON.

--This script was created to change all Databases to "Set to validate that TDE is turned on"

-- No Variables to be used in the script

USE master;

GO

SELECT

    db.name,

    db.is_encrypted,

    dm.encryption_state,

    dm.percent_complete,

    dm.key_algorithm,

    dm.key_length

FROM

    sys.databases db

    LEFT OUTER JOIN sys.dm_database_encryption_keys dm

        ON db.database_id = dm.database_id;

GO

Answer 1

Hi,

Your question is outside the scope of this Community.

Kindly repost your question in the TechNet SQL Server Forums.

https://social.technet.microsoft.com/Forums/sqlserver/en-US/home?category=sqlserver

"MSDN SQL Server Forums"

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/home?category=sqlserver

TechNet Forums:

https://social.technet.microsoft.com/Forums/en-US/home

MSDN Forums:

https://social.msdn.microsoft.com/Forums/en-US/home

Cheers.

Answer 2

This question is outside the scope of this site (for consumers) and to be sure you get the best answer it should be asked either on Technet (for IT Pro's) or MSDN (for developers)

Technet

https://social.technet.microsoft.com/forums/en-us/home

MSDN

https://social.msdn.microsoft.com/Forums/en-US/home

If you give us a link to the new thread we can point some resources to it