Skip to main content

 none
Encryption options in sql server RRS feed

  • Question

  • Hi All,

    What are the options available for SQL 2012 and SQL 2016 and Azure IaaS db's databases for encrypting backups at rest.

    If not from Sql server side, are there any other native tools from windows OS as well? Basically looking for options from sql side and os side.

    Thanks,
    Sam

    • Edited by Samantha v Tuesday, September 17, 2019 5:07 AM corrected typos
    Tuesday, September 17, 2019 5:06 AM

Answers

  • Hi Samatha v,

    I’m afraid you cannot create an encrypted backup in sql server 2012.

    Because SQL Server has the ability to encrypt the data while creating a backup until SQL Server 2014(12.x).For more details,please refer to Backup Encryption.

    You may try TDE instead.

    Hope it could help you.

    Best Regards,

    Amelia Gu


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Wednesday, September 18, 2019 6:43 AM

All replies