{"id":584,"date":"2017-01-22T10:34:24","date_gmt":"2017-01-22T02:34:24","guid":{"rendered":"http:\/\/suherman.asia\/w2\/?p=584"},"modified":"2017-01-22T10:34:24","modified_gmt":"2017-01-22T02:34:24","slug":"database-backup","status":"publish","type":"post","link":"http:\/\/suherman.asia\/w2\/database-backup.html","title":{"rendered":"Database Backup"},"content":{"rendered":"

Melakukan pekerjaan Backup untuk sebuah database adalah sebuah keharusan, tidak peduli database yang dikelola itu besar atau kecil. Hal ini dilakukan sebagai tindakan preventif apabila terjadi kerusakan atau kehilangan data. Apa jadinya ketika database kita mengalami kerusakan dan kita tidak memiliki Backup ? tentunya hal ini akan menjadi sebuah bencana besar.<\/p>\n

Pada hakikatnya Backup itu adalah sebuah copy dari database production yang kita simpan di sebuah tempat\/device yang sewaktu-waktu dapat kita panggil untuk direstore pada saat dibutuhkan. (ini menurut pendapat gue seh\u2026 )<\/p>\n

Di Sql Server 2008, banyak fitur yang dapat digunakan untuk meminimalkan kehilangan data. Seperti Mirroring<\/a>, Backup<\/a>, Log Shipping<\/a> yang kesemuanya dapat di \u2018ramu\u2019 menjadi sebuah skenario penyelamatan database.<\/p>\n

Beberapa catatan kecil namun penting yang saya buat saat\u00a0 melakukan backup adalah :<\/p>\n

    \n
  1. Hal yang penting dalam backup adalah adanya testing restore dari Backup yang dibuat. Pastikan bahwa Backup yang kita miliki dapat di restore<\/strong>, percuma kan kalo backupnya gak bisa direstore.<\/li>\n
  2. Bila backup disimpan ke Disk, jangan pernah menyatukan Backup dengan Database data dan log dalam Disk yang sama. Sehingga bila disk yang digunakan untuk menyimpan database data dan log tidak bisa diakses, maka backup anda masih bisa terselamatkan.<\/li>\n
  3. Bila menggunakan Differential Backup, perhatikan ukuran file yang terbentuk. Bila sama atau lebih dari ukuran file Full Backup, maka perkecil lagi jarak waktu antara Full Backup dan Differential Backup.<\/li>\n
  4. Untuk Meminimalkan kehilangan data pada saat database production failure, selalu gunakan transaction log backup pada apapun strategi backup yang anda gunakan.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"

    Melakukan pekerjaan Backup untuk sebuah database adalah sebuah keharusan, tidak peduli database yang dikelola itu besar atau kecil. Hal ini dilakukan sebagai tindakan preventif apabila terjadi kerusakan atau kehilangan data. Apa jadinya ketika database kita mengalami kerusakan dan kita tidak memiliki Backup ? tentunya hal ini akan menjadi sebuah bencana \u2026<\/p>\n

    Continue reading<\/i><\/a><\/p>\n","protected":false},"author":1,"featured_media":366,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[9,87,14,17],"class_list":["post-584","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sql-server","tag-backup","tag-sql-server","tag-t-sql","tag-tutorial"],"yoast_head":"\nDatabase 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=\"http:\/\/suherman.asia\/w2\/database-backup.html\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Database Backup - Suherman Blog\" \/>\n<meta property=\"og:description\" content=\"Melakukan pekerjaan Backup untuk sebuah database adalah sebuah keharusan, tidak peduli database yang dikelola itu besar atau kecil. Hal ini dilakukan sebagai tindakan preventif apabila terjadi kerusakan atau kehilangan data. Apa jadinya ketika database kita mengalami kerusakan dan kita tidak memiliki Backup ? tentunya hal ini akan menjadi sebuah bencana \u2026 Continue reading\" \/>\n<meta property=\"og:url\" content=\"http:\/\/suherman.asia\/w2\/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=\"2017-01-22T02:34:24+00:00\" \/>\n<meta property=\"og:image\" content=\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/02.png\" \/>\n\t<meta property=\"og:image:width\" content=\"407\" \/>\n\t<meta property=\"og:image:height\" content=\"478\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/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=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"http:\/\/suherman.asia\/w2\/database-backup.html#article\",\"isPartOf\":{\"@id\":\"http:\/\/suherman.asia\/w2\/database-backup.html\"},\"author\":{\"name\":\"admin\",\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"headline\":\"Database Backup\",\"datePublished\":\"2017-01-22T02:34:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"http:\/\/suherman.asia\/w2\/database-backup.html\"},\"wordCount\":240,\"commentCount\":0,\"publisher\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc\"},\"image\":{\"@id\":\"http:\/\/suherman.asia\/w2\/database-backup.html#primaryimage\"},\"thumbnailUrl\":\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/02.png\",\"keywords\":[\"Backup\",\"SQL Server\",\"T-SQL\",\"Tutorial\"],\"articleSection\":[\"SQL Server\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"http:\/\/suherman.asia\/w2\/database-backup.html#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/suherman.asia\/w2\/database-backup.html\",\"url\":\"http:\/\/suherman.asia\/w2\/database-backup.html\",\"name\":\"Database Backup - Suherman Blog\",\"isPartOf\":{\"@id\":\"http:\/\/suherman.asia\/w2\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/suherman.asia\/w2\/database-backup.html#primaryimage\"},\"image\":{\"@id\":\"http:\/\/suherman.asia\/w2\/database-backup.html#primaryimage\"},\"thumbnailUrl\":\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/02.png\",\"datePublished\":\"2017-01-22T02:34:24+00:00\",\"breadcrumb\":{\"@id\":\"http:\/\/suherman.asia\/w2\/database-backup.html#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/suherman.asia\/w2\/database-backup.html\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"http:\/\/suherman.asia\/w2\/database-backup.html#primaryimage\",\"url\":\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/02.png\",\"contentUrl\":\"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/02.png\",\"width\":407,\"height\":478},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/suherman.asia\/w2\/database-backup.html#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/suherman.asia\/w2\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"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":"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":"http:\/\/suherman.asia\/w2\/database-backup.html","og_locale":"en_US","og_type":"article","og_title":"Database Backup - Suherman Blog","og_description":"Melakukan pekerjaan Backup untuk sebuah database adalah sebuah keharusan, tidak peduli database yang dikelola itu besar atau kecil. Hal ini dilakukan sebagai tindakan preventif apabila terjadi kerusakan atau kehilangan data. Apa jadinya ketika database kita mengalami kerusakan dan kita tidak memiliki Backup ? tentunya hal ini akan menjadi sebuah bencana \u2026 Continue reading","og_url":"http:\/\/suherman.asia\/w2\/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":"2017-01-22T02:34:24+00:00","og_image":[{"width":407,"height":478,"url":"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/02.png","type":"image\/png"}],"author":"admin","twitter_misc":{"Written by":"admin","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"http:\/\/suherman.asia\/w2\/database-backup.html#article","isPartOf":{"@id":"http:\/\/suherman.asia\/w2\/database-backup.html"},"author":{"name":"admin","@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"headline":"Database Backup","datePublished":"2017-01-22T02:34:24+00:00","mainEntityOfPage":{"@id":"http:\/\/suherman.asia\/w2\/database-backup.html"},"wordCount":240,"commentCount":0,"publisher":{"@id":"http:\/\/suherman.asia\/w2\/#\/schema\/person\/63654a129ee88012961c1a00415967dc"},"image":{"@id":"http:\/\/suherman.asia\/w2\/database-backup.html#primaryimage"},"thumbnailUrl":"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/02.png","keywords":["Backup","SQL Server","T-SQL","Tutorial"],"articleSection":["SQL Server"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["http:\/\/suherman.asia\/w2\/database-backup.html#respond"]}]},{"@type":"WebPage","@id":"http:\/\/suherman.asia\/w2\/database-backup.html","url":"http:\/\/suherman.asia\/w2\/database-backup.html","name":"Database Backup - Suherman Blog","isPartOf":{"@id":"http:\/\/suherman.asia\/w2\/#website"},"primaryImageOfPage":{"@id":"http:\/\/suherman.asia\/w2\/database-backup.html#primaryimage"},"image":{"@id":"http:\/\/suherman.asia\/w2\/database-backup.html#primaryimage"},"thumbnailUrl":"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/02.png","datePublished":"2017-01-22T02:34:24+00:00","breadcrumb":{"@id":"http:\/\/suherman.asia\/w2\/database-backup.html#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["http:\/\/suherman.asia\/w2\/database-backup.html"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"http:\/\/suherman.asia\/w2\/database-backup.html#primaryimage","url":"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/02.png","contentUrl":"http:\/\/suherman.asia\/w2\/wp-content\/uploads\/2014\/08\/02.png","width":407,"height":478},{"@type":"BreadcrumbList","@id":"http:\/\/suherman.asia\/w2\/database-backup.html#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/suherman.asia\/w2"},{"@type":"ListItem","position":2,"name":"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\/584","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=584"}],"version-history":[{"count":1,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/584\/revisions"}],"predecessor-version":[{"id":585,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/posts\/584\/revisions\/585"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/media\/366"}],"wp:attachment":[{"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/media?parent=584"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/categories?post=584"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/suherman.asia\/w2\/wp-json\/wp\/v2\/tags?post=584"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}