Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

sql2008 encryption algorithm

Posted on 2012-03-24
1
Medium Priority
?
390 Views
Last Modified: 2012-04-11
Following below are encryption available for db mirroring use in sql2008. I wonder which one of these are provide very strong  to the least encryption? I heard that using strong encryption will use a lot of cpu resources, so I'm thinking to use the most suitable for our environment.

 [ALGORITHM { RC4 | AES | AES RC4 | RC4 AES } ]
0
Comment
Question by:motioneye
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
1 Comment
 
LVL 43

Accepted Solution

by:
Eugene Z earned 2000 total points
ID: 37763216
yes, you are right about CPU resources...
The rest it is up to your environment

check the below articles

Choosing an Encryption Algorithm
http://technet.microsoft.com/en-us/library/ms345262.aspx 

--
for db mirroring
Database Mirroring (OLTP)---a Technical Reference Guide for Designing Mission-Critical OLTP Solutions
http://technet.microsoft.com/en-us/library/hh393563(v=sql.110).aspx

Database Mirroring Best Practices and Performance Considerations
http://technet.microsoft.com/en-us/library/cc917681.aspx


Things to consider when setting up database mirroring in SQL Server.
http://support.microsoft.com/kb/2001270

Database Mirroring Endpoint
http://msdn.microsoft.com/en-us/library/ms179511.aspx

Database Mirroring Transport Security

http://msdn.microsoft.com/en-us/library/ms186360.aspx
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

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.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

636 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