{"id":55,"date":"2008-05-18T21:07:35","date_gmt":"2008-05-18T14:07:35","guid":{"rendered":"http:\/\/ronaldkang.com\/diary\/cara-backup-ms-sql-server-2005-database-dengan-management-studio\/"},"modified":"2012-09-06T16:50:46","modified_gmt":"2012-09-06T09:50:46","slug":"cara-backup-ms-sql-server-2005-database-dengan-management-studio","status":"publish","type":"post","link":"https:\/\/ronaldkang.com\/diary\/cara-backup-ms-sql-server-2005-database-dengan-management-studio\/","title":{"rendered":"Cara Backup MS SQL Server 2005 Database Dengan Management Studio"},"content":{"rendered":"<p> taken from <a href=\"http:\/\/www.hostmysite.com\/support\/sql\/backup2005\/\" target=\"_blank\">http:\/\/www.hostmysite.com\/support\/sql\/backup2005\/<\/a> for personal documentation<\/p>\n<p>To backup your MS SQL Server 2005 database, please follow these steps:<\/p>\n<p><!--more--><\/p>\n<ol>\n<li>Open <strong>SQL Server Management Studio<\/strong>.<\/li>\n<li>Connect to your MS SQL Server database.<\/li>\n<li>Right-click your database, expand <strong>All Tasks<\/strong> and select <strong>Back Up<\/strong>.<br \/>\n<img decoding=\"async\" src=\"http:\/\/ronaldkang.com\/diary\/wp-content\/uploads\/2012\/09\/backup200511.gif\" \/><\/li>\n<li>Under <strong>Backup type<\/strong>, select <strong>Full<\/strong>.<\/li>\n<li>Under <strong>Destination<\/strong>, click <strong>Add<\/strong>.<br \/>\n<img decoding=\"async\" src=\"http:\/\/ronaldkang.com\/diary\/wp-content\/uploads\/2012\/09\/backup20053.gif\" \/><\/li>\n<li>Enter the path and file name for the backup file.<br \/>\n<img decoding=\"async\" src=\"http:\/\/ronaldkang.com\/diary\/wp-content\/uploads\/2012\/09\/backup20054.gif\" \/><\/li>\n<li>Click <strong>OK<\/strong>.<\/li>\n<li>Review the settings for the backup.<br \/>\n<img decoding=\"async\" src=\"http:\/\/ronaldkang.com\/diary\/wp-content\/uploads\/2012\/09\/backup20055.gif\" \/><\/li>\n<li>Click <strong>OK<\/strong> to begin the backup.<\/li>\n<p>The instructions above will create a complete backup of your database. This is the recommended method to ensure that all data is backed up.<\/ol>\n<p><!-- end maincontent --><\/p>\n<form method=\"get\" action=\"http:\/\/search.hostmysite.com\/search\"> \t\t\t\t\t\t<\/form>\n<p><!--insert footer--><\/p>\n","protected":false},"excerpt":{"rendered":"<p>taken from http:\/\/www.hostmysite.com\/support\/sql\/backup2005\/ for personal documentation To backup your MS SQL Server 2005 database, please follow these steps:<\/p>\n","protected":false},"author":1,"featured_media":363,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[215],"tags":[],"class_list":["post-55","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/ronaldkang.com\/diary\/wp-json\/wp\/v2\/posts\/55","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ronaldkang.com\/diary\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ronaldkang.com\/diary\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ronaldkang.com\/diary\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ronaldkang.com\/diary\/wp-json\/wp\/v2\/comments?post=55"}],"version-history":[{"count":2,"href":"https:\/\/ronaldkang.com\/diary\/wp-json\/wp\/v2\/posts\/55\/revisions"}],"predecessor-version":[{"id":425,"href":"https:\/\/ronaldkang.com\/diary\/wp-json\/wp\/v2\/posts\/55\/revisions\/425"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ronaldkang.com\/diary\/wp-json\/wp\/v2\/media\/363"}],"wp:attachment":[{"href":"https:\/\/ronaldkang.com\/diary\/wp-json\/wp\/v2\/media?parent=55"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ronaldkang.com\/diary\/wp-json\/wp\/v2\/categories?post=55"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ronaldkang.com\/diary\/wp-json\/wp\/v2\/tags?post=55"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}