I need to protect a Microsoft SQL Server 2008 data file (.mdf) against restoring/attaching on another machine. I'm aware of TDE or Transparent Data Encryption but unfortunately this option is not available in Express version. Any other way to protect the database?
Thanks
asked Nov 18, 2014 at 1:10
Asiri GunawardenaAsiri Gunawardena
-
I assume you're asking because you want to secure your database from local administrators? This question might be relevant: dba.stackexchange.com/questions/34684/…Reaces– Reaces2014年11月18日 12:59:01 +00:00Commented Nov 18, 2014 at 12:59
2 Answers 2
You cannot do encryption with express edition but can you can do it by other way
or file encryption only. For more reference follow http://sqlmag.com/database-security/sql-server-encryption-options.
-
I'm sorry but the link seems to be broken - could you recall what was it's content?Ferdinand Fejskid– Ferdinand Fejskid2019年09月12日 14:09:07 +00:00Commented Sep 12, 2019 at 14:09
I hope it is ok to mention our third party product here, NetLib Encryptionizer. It provides Transparent Data Encryption for all versions and editions of SQL Server including SQL Express.
I am the Founder and CTO of NetLib Security Inc.
answered Mar 26, 2018 at 13:42
-
Totally fine as long as you disclose your affiliation, Neil. Can you provide some more details about the product, though? Cost, performance stats, or something? Link only answers are generally less helpful than ones that contain at least some of the content of the site linked to.LowlyDBA - John M– LowlyDBA - John M2018年03月26日 14:00:48 +00:00Commented Mar 26, 2018 at 14:00
lang-sql