{"id":477,"date":"2019-12-31T02:54:54","date_gmt":"2019-12-31T02:54:54","guid":{"rendered":"http:\/\/kloxo.web.id\/?p=477"},"modified":"2019-12-31T02:55:08","modified_gmt":"2019-12-31T02:55:08","slug":"restore-mssql-server-database-di-ubuntu","status":"publish","type":"post","link":"https:\/\/kloxo.web.id\/?p=477","title":{"rendered":"Restore MSSQL server database di ubuntu"},"content":{"rendered":"\n<p>ringkasnya ini dimaksudkan untuk merestore database yg dikirimkan dari simda (mssql2000) lanjutkan upgrade oleh mssql2008 dan agar dapat digunakan lebih lanjut oleh mssql2012 di ubuntu.<\/p>\n\n\n\n<p>1. sudo mkdir -p \/var\/opt\/mssql\/backup<\/p>\n\n\n\n<p>2. sudo mv \/home\/user\/usersdb_erp_bc.bak \/var\/opt\/mssql\/backup\/ <\/p>\n\n\n\n<p>3. sqlcmd -S localhost -U SA<\/p>\n\n\n\n<table class=\"wp-block-table\"><tbody><tr><td>1&gt; RESTORE FILELISTONLY from DISK = &#8216;\/var\/opt\/mssql\/backup\/usersdb_erp_bc.bak&#8217;<\/td><\/tr><tr><td>2&gt; GO<\/td><\/tr><\/tbody><\/table>\n\n\n\n<p>didapatkan logical name database dimaksud<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>UsersDB_ERP_QL<\/li><li>UsersDB_ERP_Log<\/li><\/ul>\n\n\n\n<p>perintah restore sbb :<\/p>\n\n\n\n<table class=\"wp-block-table\"><tbody><tr><td>1&gt; RESTORE DATABASE UsersDB_ERP_BC<\/td><\/tr><tr><td>2&gt; FROM DISK = &#8216;\/var\/opt\/mssql\/backup\/usersdb_erp_bc.bak&#8217;<\/td><\/tr><tr><td>3&gt; WITH MOVE &#8216;UsersDB_ERP_QL&#8217; TO &#8216;\/var\/opt\/mssql\/data\/UsersDB_ERP.mdf&#8217;,<\/td><\/tr><tr><td>4&gt; MOVE &#8216;UsersDB_ERP_QL_log&#8217; TO &#8216;\/var\/opt\/mssql\/data\/UsersDB_ERP.ldf&#8217;<\/td><\/tr><tr><td>5&gt; GO<\/td><\/tr><\/tbody><\/table>\n\n\n\n<p>selamat mencoba<\/p>\n\n\n\n<p>sumber : https:\/\/medium.com\/@amalrikmaia\/how-to-restore-a-sql-server-database-on-ubuntu-437882a134bf<\/p>\n","protected":false},"excerpt":{"rendered":"<p>ringkasnya ini dimaksudkan untuk merestore database yg dikirimkan dari simda (mssql2000) lanjutkan upgrade oleh mssql2008 dan agar dapat digunakan lebih lanjut oleh mssql2012 di ubuntu. 1. sudo mkdir -p \/var\/opt\/mssql\/backup 2. sudo mv \/home\/user\/usersdb_erp_bc.bak \/var\/opt\/mssql\/backup\/ 3. sqlcmd -S localhost -U SA 1&gt; RESTORE FILELISTONLY from DISK = &#8216;\/var\/opt\/mssql\/backup\/usersdb_erp_bc.bak&#8217; 2&gt; GO didapatkan logical name database dimaksud [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-477","post","type-post","status-publish","format-standard","hentry","category-linux-server"],"_links":{"self":[{"href":"https:\/\/kloxo.web.id\/index.php?rest_route=\/wp\/v2\/posts\/477","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/kloxo.web.id\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/kloxo.web.id\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/kloxo.web.id\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/kloxo.web.id\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=477"}],"version-history":[{"count":1,"href":"https:\/\/kloxo.web.id\/index.php?rest_route=\/wp\/v2\/posts\/477\/revisions"}],"predecessor-version":[{"id":478,"href":"https:\/\/kloxo.web.id\/index.php?rest_route=\/wp\/v2\/posts\/477\/revisions\/478"}],"wp:attachment":[{"href":"https:\/\/kloxo.web.id\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=477"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/kloxo.web.id\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=477"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/kloxo.web.id\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}