Post reply

Database Master Key - Backup Question

  • October 17, 2017 at 8:21 am

    #339904

    All,

    I'm looking at setting up column encryption on a 2016 Standard AG so one of the steps is to create the database master key.

    When I look through tutorials e.t.c. there is always specific mention of backing up the master key. My understanding is the key is in the database so as I'm doing full database backups the key will be stored in my backups anyway?

    I'm just wondering if I missed something as it's always specifically mentioned or whether it's just mentioned as good practice?

    Thanks

  • October 17, 2017 at 10:47 am

    #1964063

    as1981 - Tuesday, October 17, 2017 8:21 AM

    All,

    I'm looking at setting up column encryption on a 2016 Standard AG so one of the steps is to create the database master key.

    When I look through tutorials e.t.c. there is always specific mention of backing up the master key. My understanding is the key is in the database so as I'm doing full database backups the key will be stored in my backups anyway?

    I'm just wondering if I missed something as it's always specifically mentioned or whether it's just mentioned as good practice?

    Thanks

    The only way to restore the key is from the backup of the key. You can't get it from the database. That's why it's always mentioned - it's important to backup the key. 

    Sue

  • October 17, 2017 at 10:51 am

    #1964064

    Thanks. That makes sense. I knew I'd missed something but couldn't work out what.

Viewing 3 posts - 1 through 2 (of 2 total)

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