\n
USE<\/span> master<\/pre>\n<\/p>\n
GO<\/span><\/pre>\n<\/p>\n
CREATE<\/span> DATABASE<\/span> Toko <\/pre>\n<\/p>\n
GO<\/span><\/pre>\n<\/p>\n
ALTER<\/span> DATABASE<\/span> Toko SET<\/span> COMPATIBILITY_LEVEL = 100<\/pre>\n<\/p>\n
GO<\/span><\/pre>\n<\/p>\n
USE<\/span> Toko<\/pre>\n<\/p>\n
GO<\/span><\/pre>\n<\/p>\n
CREATE<\/span> TABLE<\/span> dbo.Sales_Product(<\/pre>\n<\/p>\n
fld1 char<\/span>(50) NULL<\/span>,<\/pre>\n<\/p>\n
fld2 char<\/span>(50) NULL<\/span><\/pre>\n<\/p>\n
) ON<\/span> [PRIMARY<\/span>]<\/pre>\n<\/p>\n
GO<\/pre>\n<\/div>\n
Pertama kita buat terlebih dahulu database masterkey di master database :<\/p><\/div>\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 = 'P4ssw0rD'<\/span> <\/pre>\n<\/div>\n<\/div>\n
Setelah itu kita buat server-based certificate yang nantinya akan kita gunakan untuk mengenkripsi database yang kita inginkan, kita pilih saja database Toko yang sudah kita siapkan sebelumnya.<\/p>\n
\n
\n
CREATE<\/span> CERTIFICATE TokoCert <\/pre>\n<\/p>\n
WITH<\/span> SUBJECT = 'Certificate for Toko database'<\/span> <\/pre>\n<\/div>\n<\/div>\n
Setelah itu kita buat \u201cDatabase Encryption Key\u201d untuk database Toko tersebut dengan T-SQL berikut :<\/p>\n
\n
\n
USE<\/span> Toko <\/pre>\n<\/p>\n
GO<\/span> <\/pre>\n<\/p>\n
CREATE<\/span> DATABASE<\/span> ENCRYPTION KEY<\/span> <\/pre>\n<\/p>\n
WITH<\/span> ALGORITHM = AES_128 <\/pre>\n<\/p>\n
ENCRYPTION BY<\/span> SERVER CERTIFICATE TokoCert<\/pre>\n<\/p>\n
GO<\/pre>\n<\/div>\n<\/div>\n
Setelah itu kita aktifkan Enkripsi pada level database Toko<\/p>\n
\n
\n
ALTER<\/span> DATABASE<\/span> toko<\/pre>\n<\/p>\n
SET<\/span> ENCRYPTION ON<\/span> <\/pre>\n<\/div>\n<\/div>\n
Sekarang database kita sudah menggunakan TDE, mari kita coba backup database Toko<\/p>\n
\n
\n
BACKUP<\/span> DATABASE<\/span> Toko <\/pre>\n<\/p>\n
TO<\/span> DISK<\/span> = 'E:\\Toko.bak'<\/span> <\/pre>\n<\/p>\n
WITH<\/span> INIT, STATS = 10<\/pre>\n<\/div>\n<\/div>\n
Kalo kita perhatikan, waktu backup database kita sekarang menjadi lebih lama dibanding ketika database belum di Enkripsi. Saat ini hasil backup database Toko telah terenkripsi<\/p>\n
Demikian selamat mencoba.<\/p>\n","protected":false},"excerpt":{"rendered":"
Hasil Backup suatu database dapat dengan mudah untuk bisa di restore di engine SQL Server lain manapun. Tentunya hal ini sangat berbahaya jika hasil backup yang kita hasilkan tercuri atau di copy oleh lawan bisnis kita. Namun sejak versi SQL Server 2008 telah tersedia sebuah fitur \u201cTransparent Data Encryption\u201d yang \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":[8,87],"class_list":["post-19","post","type-post","status-publish","format-standard","hentry","category-sql-server","tag-encrypt","tag-sql-server"],"yoast_head":"\nEncrypt Database Backup - 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=\"https:\/\/suherman.asia\/w2\/encrypt-database-backup.html\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Encrypt Database Backup - Suherman Blog\" \/>\n<meta property=\"og:description\" content=\"Hasil Backup suatu database dapat dengan mudah untuk bisa di restore di engine SQL Server lain manapun. Tentunya hal ini sangat berbahaya jika hasil backup yang kita hasilkan tercuri atau di copy oleh lawan bisnis kita. Namun sejak versi SQL Server 2008 telah tersedia sebuah fitur \u201cTransparent Data Encryption\u201d yang \u2026 Continue reading\" \/>\n<meta property=\"og:url\" content=\"https:\/\/suherman.asia\/w2\/encrypt-database-backup.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:11:16+00:00\" \/>\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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/suherman.asia\/w2\/encrypt-database-backup.html#article\",\"isPartOf\":{\"@id\":\"https:\/\/suherman.asia\/w2\/encrypt-database-backup.html\"},\"author\":{\"name\":\"admin\",\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"headline\":\"Encrypt Database Backup\",\"datePublished\":\"2014-01-02T13:11:16+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/suherman.asia\/w2\/encrypt-database-backup.html\"},\"wordCount\":187,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"keywords\":[\"Encrypt\",\"SQL Server\"],\"articleSection\":[\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/suherman.asia\/w2\/encrypt-database-backup.html#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/suherman.asia\/w2\/encrypt-database-backup.html\",\"url\":\"https:\/\/suherman.asia\/w2\/encrypt-database-backup.html\",\"name\":\"Encrypt Database Backup - Suherman Blog\",\"isPartOf\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#website\"},\"datePublished\":\"2014-01-02T13:11:16+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/suherman.asia\/w2\/encrypt-database-backup.html#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/suherman.asia\/w2\/encrypt-database-backup.html\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/suherman.asia\/w2\/encrypt-database-backup.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/suherman.asia\/w2\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Encrypt Database Backup\"}]},{\"@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":"Encrypt Database Backup - 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":"https:\/\/suherman.asia\/w2\/encrypt-database-backup.html","og_locale":"en_US","og_type":"article","og_title":"Encrypt Database Backup - Suherman Blog","og_description":"Hasil Backup suatu database dapat dengan mudah untuk bisa di restore di engine SQL Server lain manapun. Tentunya hal ini sangat berbahaya jika hasil backup yang kita hasilkan tercuri atau di copy oleh lawan bisnis kita. Namun sejak versi SQL Server 2008 telah tersedia sebuah fitur \u201cTransparent Data Encryption\u201d yang \u2026 Continue reading","og_url":"https:\/\/suherman.asia\/w2\/encrypt-database-backup.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:11:16+00:00","author":"admin","twitter_misc":{"Written by":"admin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/suherman.asia\/w2\/encrypt-database-backup.html#article","isPartOf":{"@id":"https:\/\/suherman.asia\/w2\/encrypt-database-backup.html"},"author":{"name":"admin","@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"headline":"Encrypt Database Backup","datePublished":"2014-01-02T13:11:16+00:00","mainEntityOfPage":{"@id":"https:\/\/suherman.asia\/w2\/encrypt-database-backup.html"},"wordCount":187,"commentCount":0,"publisher":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"keywords":["Encrypt","SQL Server"],"articleSection":["SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/suherman.asia\/w2\/encrypt-database-backup.html#respond"]}]},{"@type":"WebPage","@id":"https:\/\/suherman.asia\/w2\/encrypt-database-backup.html","url":"https:\/\/suherman.asia\/w2\/encrypt-database-backup.html","name":"Encrypt Database Backup - Suherman Blog","isPartOf":{"@id":"http:\/\/suherman.asia\/w2\/#website"},"datePublished":"2014-01-02T13:11:16+00:00","breadcrumb":{"@id":"https:\/\/suherman.asia\/w2\/encrypt-database-backup.html#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/suherman.asia\/w2\/encrypt-database-backup.html"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/suherman.asia\/w2\/encrypt-database-backup.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/suherman.asia\/w2"},{"@type":"ListItem","position":2,"name":"Encrypt Database Backup"}]},{"@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\/19","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=19"}],"version-history":[{"count":1,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/19\/revisions"}],"predecessor-version":[{"id":20,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/19\/revisions\/20"}],"wp:attachment":[{"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/media?parent=19"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/categories?post=19"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/tags?post=19"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}