none
Backup Encryption in SQL Server Standard Edition

    Question

  • Hello,

    I need experts advice on Backup encryption options available in SQL Server 2008 R2 Standard Edition. I know TDE is available, but only in Sql Server 2008 R2 Enterprise edition. But we are using Standard Edition.

    Thanks


    • Edited by SQLSPUser Sunday, January 26, 2014 11:14 PM
    Sunday, January 26, 2014 11:12 PM

Answers

  • Not possible for Standard, but you can use Veritas Backup Exec
    Sunday, January 26, 2014 11:57 PM
  • Password protect is not the same thing as encryption - the data is still clear text. This is what Books Online for SQL Server 2008 say about the password option:

    "The protection provided by this password is weak. It is intended to prevent an incorrect restore using SQL Server tools by authorized or unauthorized users. It does not prevent the reading of the backup data by another method or the replacement of the password. This feature will be removed in the next version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. "

    And in 2012 this option is indeed removed from the backup command.


    Tibor Karaszi, SQL Server MVP | web | blog

    Monday, January 27, 2014 4:35 PM

All replies

  • Not possible for Standard, but you can use Veritas Backup Exec
    Sunday, January 26, 2014 11:57 PM
  • Not possible for Standard, but you can use Veritas Backup Exec
    I think it is possible to do this with mediapassword option. 
    Monday, January 27, 2014 2:12 AM
  • Password protect is not the same thing as encryption - the data is still clear text. This is what Books Online for SQL Server 2008 say about the password option:

    "The protection provided by this password is weak. It is intended to prevent an incorrect restore using SQL Server tools by authorized or unauthorized users. It does not prevent the reading of the backup data by another method or the replacement of the password. This feature will be removed in the next version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. "

    And in 2012 this option is indeed removed from the backup command.


    Tibor Karaszi, SQL Server MVP | web | blog

    Monday, January 27, 2014 4:35 PM