Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Encryption   (RSS)

Setting up Database mirroring in SQL Server 2008 using T-SQL when the database is encrypted using Transparent Data Encryption.

Consider the following Scenario, You are using SQL Server 2008 Enterprise edition RTM or higher version and you are Transparent database encryption (new feature introduce in SQL Server 2008) to encrypt the Database to be mirrored. The database encryption Read More...
Posted Tuesday, March 31, 2009 3:03 PM by sanjayap | 11 Comments

How to change the keys for the Encryption for an already encrypted database

Have you ever wondered how to change the keys for the encryption for an already encrypted database. For this you can use "Key Rotation". Key rotation is the process of decrypting data with the old encryption key and encrypting the data with the new encryption Read More...
Posted Monday, August 11, 2008 3:07 AM by sanjayap | 1 Comments

Regeneration of the Master Key fails when we try to take the backup of the Original Database and Restore on other instance of SQL server on other Machine

We have a production database in which the data is encrypted. The encryption follows the following hierarchy 1) The data is encrypted using Symmetric key 2) The symmetric key was encrypted using asymmetric key 3) The asymmetric key was encrypted using Read More...
Posted Wednesday, July 16, 2008 1:32 PM by sanjayap | 3 Comments
 
Page view tracker