April 24, 2014 at 3:32 pm
All,
I have an urgent requirement to implement encryption (Data at rest) for our SQL 2005 instance. Please let me know your thoughts if I can accomplish this through SQL server or using any other tools.
It would be very helpful if these topics can be explained.
* What is data at rest
* Can SQL server accomplish the requirement for data at rest?
* Is it simply just to make sure the database backups cannot be used without the encryption key.
* If there is a viable option, what would be the rough estimate to accomplish this?
Many thanks in advance!
April 26, 2014 at 10:57 am
SQL!$@w$0ME (4/24/2014)
All,I have an urgent requirement to implement encryption (Data at rest) for our SQL 2005 instance. Please let me know your thoughts if I can accomplish this through SQL server or using any other tools.
It would be very helpful if these topics can be explained.
* What is data at rest
* Can SQL server accomplish the requirement for data at rest?
* Is it simply just to make sure the database backups cannot be used without the encryption key.
* If there is a viable option, what would be the rough estimate to accomplish this?
Many thanks in advance!
Transparent Data Encryption is not available until SQL Server 2008, backups may be protected by using a 3rd party utility to encrypt backup files. Data files may be protected by the use of NTFS permissions on the database engine folders\files.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply