May 262014
Lessons learnt by implementing Backup Encryption

We’ve already discussed Backup Encryption feature in detail, incase you’ve not covered those please find the link: Part-1Part-2Part-3   There are a few things you must know before you implement backup encryption in your environment, here I’ll try to list them: 1. Original Certificate which was used as an encryptor should be available at the [Read More]

May 192014
Backup Encryption | Part-3

In Part-1 we discussed the feature of backup encryption and part-2 walks us through the scripts to prepare for the pre-requisites and take an encrypted backup, In part-2 we took the backup of Repro_FGDN Database on MBTEST server. We took the encrypted backup using Certificate as an encryptor and used AES_256 encryption algorithm. In this [Read More]

May 132014
Backup Encryption | Part-2

In the first part we discussed the new feature of Backup Encryption which is introduced in SQL Server 2014, the post describes the benefits, restrictions, permissions required etc. Now let’s see this in action, the below mentioned scripts will generate Service Master Key, Database Master key and a Certificate which will act as an encryptor [Read More]