[Last Call] Learn how to a build a cloud-first strategyRegister Now


How to encrypt sql server database files and backups in sql server 2012 Standard edition on Amazon cloud

Posted on 2014-08-21
Medium Priority
Last Modified: 2016-06-11

We have SQL Server 2012 Standard Edition On amazon EC2 Cloud.we would like secure our database files and backup files encrpyted.

Upon original research I thought I could use TDE but did not realize that it was only available for Enterprise or DataCenter versions of SQL Servers.

What is the most efficient and low cost method for data encryption? Should I do something through SQL Server or just use third party tools to encrypt the whole volume where DB and backups are? Also if someone can point to a way to use "Data encryption" that comes as feature in standard edition I would really appreciate. Every time I search for encryption on sql server I keep ending up on how to use TDE and in current scenario it is not feasible for the size of business to purchase Enterprise Edition.

Thanks in Advance.
Question by:ccfcfc
LVL 40

Accepted Solution

lcohan earned 1000 total points
ID: 40277029
One way to do that on Standard edition would be: "Through the strategic use of SQL Views and Triggers, you can automate encryption of sensitive data on your SQL Server without extensive program modifications, and still use a secure key management HSM to protect the encryption keys."


Assisted Solution

by:Randy Knight, MCM
Randy Knight, MCM earned 1000 total points
ID: 40281200
If your requirement is to encrypt the data at rest, TDE is really your best option.  Encrypting data inside the database does not usually meet the requirements for encrypting at rest.  On standard edition, ther might be some 3rd party solutions that could work but I haven't worked with any of them.

Author Comment

ID: 40341234
Thanks for your responses.

Can anyone list some third party tools which support encryption on sql server 2012 standard edition please.


Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
One of the most important things in an application is the query performance. This article intends to give you good tips to improve the performance of your queries.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question