question

basit 1 avatar image
basit 1 asked

How to restore Database which have service master key

Hello Everyone, I have one Database which have Master_key enable , now i want to restore that database on the other server , so how do it proceed it. use [master]; select * from sys.symmetric_keys; when i execute this query i get one record for master_key Scenario : i need to restore my PROD Database with this master key to my QA Database which have also a master key
databaserestoremaster-key
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Håkan Winther avatar image
Håkan Winther answered
Take a look at the script in my blog post. (The post is in Swedish, but you can probably understand the process in the script) If your database is encrypted by a certificate, you need to take a backup of the certificate. [ http://www.sqlservice.se/sv/start/blogg/sql-server--transparent-data-encryption.aspx][1] [1]: http://www.sqlservice.se/sv/start/blogg/sql-server--transparent-data-encryption.aspx
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.