Database Master Key (DMK)

Note: Is is the Database Master Key (DMK). It is not the Service Master Key (SMK). The database master key is a symmetric key used to protect the private keys of certificates and asymmetric keys that are present in the database. When it is created, the master key is encrypted by using the AES_256 algorithm and a user-supplied password. Database master key is stored in both... » read more

Service Master Key (SMK)

Note: This is for Service Master Key (SMK). This is not the same as Database Master Key (DMK). The service master key is the root of the SQL Server encryption hierarchy. The service master key directly or indirectly secures all other keys in the tree. If a dependent key cannot be decrypted during a forced... » read more

TDE and Encryption Keys

SQL Server uses encryption keys to help secure data, credentials, and connection information that is stored in a server database. SQL Server has two kinds of keys: symmetric and asymmetric. Symmetric keys use the same password to encrypt and decrypt data. Asymmetric keys use one password to encrypt data (called the public key) and another to decrypt data (called... » read more

TDE and Database Backup and Recovery

Back up the master key and certificate that are used for TDE to a safe location. The master key and certificate are required to restore backups that were taken when the database was encrypted with TDE. After you remove the database encryption key, take a log backup followed by a fresh full backup of the... » read more

TDE and Always On

TDE and Always On You can add an encrypted database to Always On availability group. To encrypt databases that are part of an availability group, create the master key and certificates, or asymmetric key (EKM) on all secondary replicas before creating the database encryption key on the primary replica. If a certificate is used to protect the database... » read more

Enable TDE on SQL Server

Create Database Master Key and Certificate Note: USE master database. You should backup the Certificate (With Master Key) as soon as you create the certificate. Note: You can not create a Master Key if a Master Key is already created. You can not drop a Master Key if there are existing Certificate created with the... » read more

Maintenance Plans Wizard

Tasks Check Database Integrity Shrink Database Reorganize Index Rebuild Index Update Statistics Clean Up History Execute SQL Server Agent Job Back Up Database (Full) Back Up Database (Differential) Back Up Database (Transaction Log) Maintenance Cleanup Task

Synonyms

A synonym is a database object that serves the following purposes: Provides an alternative name for another database object, referred to as the base object, that can exist on a local or remote server. Provides a layer of abstraction that protects a client application from changes made to the name or location of the base... » read more