This intricacy has turned it into a resource-intensive process. The receiver, on the other hand, can use his key to decrypt the message but he cannot encrypt it. This is a relatively complex system where the sender can use his key to encrypt the message but he cannot decrypt it.

Asymmetric Key – Asymmetric cryptography, also known as Public-key cryptography, is a system in which the sender and the receiver of a message have a pair of cryptographic keys – a public key and a private key – to encrypt and decrypt the message.This is relatively easy to implement, and both the sender and the receiver can encrypt or decrypt the messages. Symmetric Key – In Symmetric cryptography system, the sender and the receiver of a message share a single, common key that is used to encrypt and decrypt the message.There are two kinds of keys used in encryption: Database Level – Lower Level – Uses Database Master Key for encryption.SQL Server Level – Moderate Level – Uses Services Master Key for encryption.

Windows Level – Highest Level – Uses Windows DP API for encryption.Different levels of hierarchies allow multiple instances of services (e.g., SQL Server Services) to run on one physical server. These three levels provide different mechanisms for securing data across networks and local servers. Nowadays, it has become imperative to encrypt crucial security-related data while storing in the database as well as during transmission across a network between the client and the server.Įncryption hierarchy is marked by three-level security. Hackers might be able to penetrate the database or tables, but owing to encryption they would not be able to understand the data or make use of it.

SQL Server 2005 and SQL Server 2008 provide encryption as a new feature to protect data against hackers’ attacks.

Backup master key sql server