October 2010
Intermediate to advanced
1008 pages
46h 16m
English
TDE will immediately begin to encrypt the content DB. It can do this on the fly as the database is being used. Depending on the size of the database, this might take a while. Progress of the encryption can be monitored with another script shown here, which returns all database with encryption state 3. An encryption state of 1 = no encryption, whereas a state of 2 indicates that encryption has begun. A state of 3 means that encryption is complete. Run this command until the results show the database as having a state of 3, as shown in Figure 17.11. The TDE encryption process will then be complete:

Figure 17.11. Monitoring TDE ...
Read now
Unlock full access