{"id":21,"date":"2014-01-02T21:13:41","date_gmt":"2014-01-02T13:13:41","guid":{"rendered":"http:\/\/suherman.asia\/w2\/?p=21"},"modified":"2014-01-02T21:13:41","modified_gmt":"2014-01-02T13:13:41","slug":"how-to-restore-encrypted-database-backup-file","status":"publish","type":"post","link":"http:\/\/suherman.asia\/w2\/how-to-restore-encrypted-database-backup-file.html","title":{"rendered":"How to Restore Encrypted Database Backup File"},"content":{"rendered":"

Melanjutkan blog saya sebelumnya mengenai Encrypt Database Backup<\/a>, berikut ini coba saya paparkan bagaiman merestore sebuah backup database pada database yang berada pada beda instance.<\/p>\n

Untuk mempermudah penjelasan, Instance dimana database Toko yang sebenarnya berada kita sebut \u201cInstance Asli\u201d. Sedangkan Instance tempat kita akan melakukan proses restore kita sebut \u201cInstance Restore\u201d.<\/p>\n

Pada Instance Restore pertama saya buat sebuah database Toko terlebih dahulu, setelah itu saya coba restore menggunakan hasil backup pada blog sebelumnya<\/a> atau hasil backup dari \u201cInstance Asli\u201d. ternyata ketika saya coba restore (instance ini menggunakan SQL Server 2008 R2) timbul notifikasi error seperti dibawah ini. :<\/p>\n

\"image\"<\/a><\/p>\n

ternyata proses restore ini membutuhkan Server Certificate. Agar kita bisa melakukan tindakan restore ini, kita harus mendapatkan certificate dari \u201cInstance Asli\u201d. Langkahnya adalah kita harus bisa mengeksport certificate database Toko data \u201cInstance Asli\u201d ke database Toko \u201cInstance Restore\u201d.<\/p>\n

Mari kita ke \u201cInstance Asli\u201d terlebih dahulu dan lakukan T-SQL ini :<\/p>\n

\n
\n
USE<\/span> master <\/pre>\n
<\/p>\n
GO<\/span> <\/pre>\n
<\/p>\n
BACKUP<\/span> CERTIFICATE TokoCert  <\/pre>\n
<\/p>\n
TO<\/span> FILE<\/span> = 'E:\\TokoCert_File.cer'<\/span> <\/pre>\n
<\/p>\n
WITH<\/span> PRIVATE KEY<\/span> (FILE<\/span> = 'E:\\TokoCert_Key.pvk'<\/span> , <\/pre>\n
<\/p>\n
ENCRYPTION BY<\/span> PASSWORD = 'P4ssw0rD'<\/span> ) <\/pre>\n
<\/p>\n
GO<\/pre>\n
<\/div>\n<\/div>\n
Langkah ini menghasilkan 2 buah file yaitu 1 buah File Certificate dan 1 buah private key<\/p>\n
\"image\"<\/a><\/p>\n
Langkah selanjutnya adalah mengimport file certificate yang sudah terbentuk ke database toko yang ada di \u201cInstance Restore\u201d. Sebelum itu kita buat terlebih dahulu master key di \u201cInstance Restore\u201d. mari kita beralih ke \u201cInstance Restore\u201d dan jalankan T-SQL berikut :<\/p>\n
\n
\n
USE<\/span> master <\/pre>\n
<\/p>\n
GO<\/span> <\/pre>\n
<\/p>\n
CREATE<\/span> MASTER KEY<\/span> ENCRYPTION BY<\/span> PASSWORD = 'Restore_P4ssw0rd'<\/span> <\/pre>\n
<\/p>\n
GO<\/span> <\/pre>\n
<\/div>\n
untuk kebutuhan password dapat disesuaikan oleh anda.<\/p><\/div>\n
 <\/div>\n
Setelah itu kita create Certificate di database Toko yang ada di \u201cInstance Resore\u201d dgn menggunakan private key dan certificate file dari database Toko \u201cInstance Asli\u201d dengan menggunakan T-SQL berikut :<\/div>\n
 <\/div>\n
\n
\n
CREATE<\/span> CERTIFICATE TokoCert <\/pre>\n
<\/p>\n
FROM<\/span> FILE<\/span> = 'E:\\TokoCert_File.cer'<\/span>  <\/pre>\n
<\/p>\n
WITH<\/span> PRIVATE KEY<\/span> (FILE<\/span> = 'E:\\TokoCert_Key.pvk'<\/span>,  <\/pre>\n
<\/p>\n
DECRYPTION BY<\/span> PASSWORD = 'P4ssw0rD'<\/span>); <\/pre>\n
<\/p>\n
GO<\/pre>\n
<\/div>\n<\/div>\n
Password yang digunakan adalah password pada saat menbuat certificate di \u201cInstance Asli\u201d.<\/p>\n
Sekarang kita coba restore hasil backup database Toko \u201cInstance Asli\u201d ke database Toko yang ada di \u201cInstance Restore\u201d dan berhasil.<\/p>\n
\"image\"<\/a><\/p>\n
Demikian, semoga bermanfaat.<\/p>\n","protected":false},"excerpt":{"rendered":"
Melanjutkan blog saya sebelumnya mengenai Encrypt Database Backup, berikut ini coba saya paparkan bagaiman merestore sebuah backup database pada database yang berada pada beda instance. Untuk mempermudah penjelasan, Instance dimana database Toko yang sebenarnya berada kita sebut \u201cInstance Asli\u201d. Sedangkan Instance tempat kita akan melakukan proses restore kita sebut \u201cInstance \u2026<\/p>\n
 Continue reading<\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[9,8,87],"class_list":["post-21","post","type-post","status-publish","format-standard","hentry","category-sql-server","tag-backup","tag-encrypt","tag-sql-server"],"yoast_head":"\nHow to Restore Encrypted Database Backup File - Suherman Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/suherman.asia\/w2\/how-to-restore-encrypted-database-backup-file.html\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to Restore Encrypted Database Backup File - Suherman Blog\" \/>\n<meta property=\"og:description\" content=\"Melanjutkan blog saya sebelumnya mengenai Encrypt Database Backup, berikut ini coba saya paparkan bagaiman merestore sebuah backup database pada database yang berada pada beda instance. Untuk mempermudah penjelasan, Instance dimana database Toko yang sebenarnya berada kita sebut \u201cInstance Asli\u201d. Sedangkan Instance tempat kita akan melakukan proses restore kita sebut \u201cInstance \u2026 Continue reading\" \/>\n<meta property=\"og:url\" content=\"http:\/\/suherman.asia\/w2\/how-to-restore-encrypted-database-backup-file.html\" \/>\n<meta property=\"og:site_name\" content=\"Suherman Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/emantin34\" \/>\n<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/emantin34\" \/>\n<meta property=\"article:published_time\" content=\"2014-01-02T13:13:41+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/image_5F00_thumb_5F00_756264D4.png\" \/>\n<meta name=\"author\" content=\"admin\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"admin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\/\/suherman.asia\/w2\/how-to-restore-encrypted-database-backup-file.html#article\",\"isPartOf\":{\"@id\":\"http:\/\/suherman.asia\/w2\/how-to-restore-encrypted-database-backup-file.html\"},\"author\":{\"name\":\"admin\",\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"headline\":\"How to Restore Encrypted Database Backup File\",\"datePublished\":\"2014-01-02T13:13:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/suherman.asia\/w2\/how-to-restore-encrypted-database-backup-file.html\"},\"wordCount\":276,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"image\":{\"@id\":\"http:\/\/suherman.asia\/w2\/how-to-restore-encrypted-database-backup-file.html#primaryimage\"},\"thumbnailUrl\":\"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/image_5F00_thumb_5F00_756264D4.png\",\"keywords\":[\"Backup\",\"Encrypt\",\"SQL Server\"],\"articleSection\":[\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\/\/suherman.asia\/w2\/how-to-restore-encrypted-database-backup-file.html#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/suherman.asia\/w2\/how-to-restore-encrypted-database-backup-file.html\",\"url\":\"http:\/\/suherman.asia\/w2\/how-to-restore-encrypted-database-backup-file.html\",\"name\":\"How to Restore Encrypted Database Backup File - Suherman Blog\",\"isPartOf\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/suherman.asia\/w2\/how-to-restore-encrypted-database-backup-file.html#primaryimage\"},\"image\":{\"@id\":\"http:\/\/suherman.asia\/w2\/how-to-restore-encrypted-database-backup-file.html#primaryimage\"},\"thumbnailUrl\":\"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/image_5F00_thumb_5F00_756264D4.png\",\"datePublished\":\"2014-01-02T13:13:41+00:00\",\"breadcrumb\":{\"@id\":\"http:\/\/suherman.asia\/w2\/how-to-restore-encrypted-database-backup-file.html#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/suherman.asia\/w2\/how-to-restore-encrypted-database-backup-file.html\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/suherman.asia\/w2\/how-to-restore-encrypted-database-backup-file.html#primaryimage\",\"url\":\"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/image_5F00_thumb_5F00_756264D4.png\",\"contentUrl\":\"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/image_5F00_thumb_5F00_756264D4.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/suherman.asia\/w2\/how-to-restore-encrypted-database-backup-file.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/suherman.asia\/w2\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to Restore Encrypted Database Backup File\"}]},{\"@type\":\"WebSite\",\"@id\":\"http:\/\/suherman.asia\/w2\/#website\",\"url\":\"http:\/\/suherman.asia\/w2\/\",\"name\":\"Suherman Blog\",\"description\":\"Just Another Geek Site\",\"publisher\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/suherman.asia\/w2\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g\",\"caption\":\"admin\"},\"logo\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/\"},\"sameAs\":[\"http:\/\/suherman.asia\",\"https:\/\/www.facebook.com\/emantin34\",\"https:\/\/x.com\/emantin34\"],\"url\":\"http:\/\/suherman.asia\/w2\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to Restore Encrypted Database Backup File - Suherman Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/suherman.asia\/w2\/how-to-restore-encrypted-database-backup-file.html","og_locale":"en_US","og_type":"article","og_title":"How to Restore Encrypted Database Backup File - Suherman Blog","og_description":"Melanjutkan blog saya sebelumnya mengenai Encrypt Database Backup, berikut ini coba saya paparkan bagaiman merestore sebuah backup database pada database yang berada pada beda instance. Untuk mempermudah penjelasan, Instance dimana database Toko yang sebenarnya berada kita sebut \u201cInstance Asli\u201d. Sedangkan Instance tempat kita akan melakukan proses restore kita sebut \u201cInstance \u2026 Continue reading","og_url":"http:\/\/suherman.asia\/w2\/how-to-restore-encrypted-database-backup-file.html","og_site_name":"Suherman Blog","article_publisher":"https:\/\/www.facebook.com\/emantin34","article_author":"https:\/\/www.facebook.com\/emantin34","article_published_time":"2014-01-02T13:13:41+00:00","og_image":[{"url":"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/image_5F00_thumb_5F00_756264D4.png","type":"","width":"","height":""}],"author":"admin","twitter_misc":{"Written by":"admin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/suherman.asia\/w2\/how-to-restore-encrypted-database-backup-file.html#article","isPartOf":{"@id":"http:\/\/suherman.asia\/w2\/how-to-restore-encrypted-database-backup-file.html"},"author":{"name":"admin","@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"headline":"How to Restore Encrypted Database Backup File","datePublished":"2014-01-02T13:13:41+00:00","mainEntityOfPage":{"@id":"http:\/\/suherman.asia\/w2\/how-to-restore-encrypted-database-backup-file.html"},"wordCount":276,"commentCount":0,"publisher":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"image":{"@id":"http:\/\/suherman.asia\/w2\/how-to-restore-encrypted-database-backup-file.html#primaryimage"},"thumbnailUrl":"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/image_5F00_thumb_5F00_756264D4.png","keywords":["Backup","Encrypt","SQL Server"],"articleSection":["SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/suherman.asia\/w2\/how-to-restore-encrypted-database-backup-file.html#respond"]}]},{"@type":"WebPage","@id":"http:\/\/suherman.asia\/w2\/how-to-restore-encrypted-database-backup-file.html","url":"http:\/\/suherman.asia\/w2\/how-to-restore-encrypted-database-backup-file.html","name":"How to Restore Encrypted Database Backup File - Suherman Blog","isPartOf":{"@id":"http:\/\/suherman.asia\/w2\/#website"},"primaryImageOfPage":{"@id":"http:\/\/suherman.asia\/w2\/how-to-restore-encrypted-database-backup-file.html#primaryimage"},"image":{"@id":"http:\/\/suherman.asia\/w2\/how-to-restore-encrypted-database-backup-file.html#primaryimage"},"thumbnailUrl":"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/image_5F00_thumb_5F00_756264D4.png","datePublished":"2014-01-02T13:13:41+00:00","breadcrumb":{"@id":"http:\/\/suherman.asia\/w2\/how-to-restore-encrypted-database-backup-file.html#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/suherman.asia\/w2\/how-to-restore-encrypted-database-backup-file.html"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/suherman.asia\/w2\/how-to-restore-encrypted-database-backup-file.html#primaryimage","url":"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/image_5F00_thumb_5F00_756264D4.png","contentUrl":"http:\/\/mugi.or.id\/cfs-file.ashx\/__key\/CommunityServer.Blogs.Components.WeblogFiles\/suherman\/image_5F00_thumb_5F00_756264D4.png"},{"@type":"BreadcrumbList","@id":"http:\/\/suherman.asia\/w2\/how-to-restore-encrypted-database-backup-file.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/suherman.asia\/w2"},{"@type":"ListItem","position":2,"name":"How to Restore Encrypted Database Backup File"}]},{"@type":"WebSite","@id":"http:\/\/suherman.asia\/w2\/#website","url":"http:\/\/suherman.asia\/w2\/","name":"Suherman Blog","description":"Just Another Geek Site","publisher":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/suherman.asia\/w2\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc","name":"admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/eed6f889b4c2af2a8c18cb3bf63de6a4?s=96&d=retro&r=g","caption":"admin"},"logo":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/image\/"},"sameAs":["http:\/\/suherman.asia","https:\/\/www.facebook.com\/emantin34","https:\/\/x.com\/emantin34"],"url":"http:\/\/suherman.asia\/w2\/author\/admin"}]}},"_links":{"self":[{"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/21","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/comments?post=21"}],"version-history":[{"count":1,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/21\/revisions"}],"predecessor-version":[{"id":22,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/21\/revisions\/22"}],"wp:attachment":[{"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/media?parent=21"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/categories?post=21"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/tags?post=21"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}