Post reply

Securing SQL Backup

  • February 1, 2017 at 12:00 am

    #334916

    Hi Experts,

    How can I encrypt or secure the backup for my SQL Server ? which is the best way to do that without creating many keys?

    Is it neccessary to create a DEK to encrypt database backups?

  • February 1, 2017 at 12:11 am

    #1926003

    VastSQL - Wednesday, February 1, 2017 12:00 AM

    Hi Experts,

    How can I encrypt or secure the backup for my SQL Server ? which is the best way to do that without creating many keys?

    Is it neccessary to create a DEK to encrypt database backups?

    What edition of SQL Server is it?
    😎

  • February 1, 2017 at 5:38 am

    #1926036

    Eirikur Eiriksson - Wednesday, February 1, 2017 12:11 AM

    VastSQL - Wednesday, February 1, 2017 12:00 AM

    Hi Experts,

    How can I encrypt or secure the backup for my SQL Server ? which is the best way to do that without creating many keys?

    Is it neccessary to create a DEK to encrypt database backups?

    What edition of SQL Server is it?
    😎

    SQL Server 2014 EE

  • February 1, 2017 at 5:40 am

    #1926038

    Figured it..

    Database Master Key and Certificate is the minimum we need to encrypt the backup.

    https://msdn.microsoft.com/en-us/library/dn449489(v=sql.120).aspx

  • February 6, 2017 at 9:46 am

    #1926906

    all detailed in my article at this link

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply