Post reply

How to restore encrypted database (bacpac file) on Local?

  • September 13, 2018 at 8:22 am

    #377302

    I have created a bacpac from azure. Here, The source database is encrypted with master key by some password then certificate and symmetric key created. Now I have to restore bacpac to my local server. However, it throws an error like “Please create a master key in the database or open the master key in the session before performing this operation”. The reason is one of the column in the table is encrypted. I don’t know how to restore the database from azure with master key and certificate etc. Do you know what I could do?

  • September 17, 2018 at 12:08 am

    This was removed by the editor as SPAM

  • October 2, 2018 at 7:38 am

    #2007688

    Johnson Welch - Monday, September 17, 2018 12:08 AM

    Check out this link. It may help you out:
    http://www.sqlservercentral.com/articles/Database+Master+Key+(DMK)/107787/

    Thanks for the info.

    But restore bacpac is not working throwing the same error. Above link described that restore got worked and error arises when running sql query in new DB instance. Mine issue is different. I get stuck at restore step only. What would be reason?

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

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