{"id":720,"date":"2020-05-13T20:20:52","date_gmt":"2020-05-13T20:20:52","guid":{"rendered":"http:\/\/jonescarvalho.com\/Blog\/?p=720"},"modified":"2020-05-13T18:42:29","modified_gmt":"2020-05-13T21:42:29","slug":"restore-database-sql-linux","status":"publish","type":"post","link":"https:\/\/jonescarvalho.com\/Blog\/?p=720","title":{"rendered":"Restore Database SQL Linux"},"content":{"rendered":"<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"sql\">RESTORE DATABASE [yourDatabase]\nFROM DISK = '\/var\/opt\/mssql\/data\/yourDatabase.bak'\nWITH MOVE 'yourDatabase' TO '\/var\/opt\/mssql\/data\/yourDatabase.mdf',\nMOVE 'yourDatabase_Log' TO '\/var\/opt\/mssql\/data\/yourDatabase.ldf'\nGO<\/pre>\n<p>Copiar para o container docker<\/p>\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"generic\">docker cp backupSQL.bak [container]:\/var\/opt\/mssql\/data<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>RESTORE DATABASE [yourDatabase] FROM DISK = &#8216;\/var\/opt\/mssql\/data\/yourDatabase.bak&#8217; WITH MOVE &#8216;yourDatabase&#8217; TO &#8216;\/var\/opt\/mssql\/data\/yourDatabase.mdf&#8217;, MOVE [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[68,76,30],"class_list":["post-720","post","type-post","status-publish","format-standard","hentry","category-dicas","tag-docker","tag-linux","tag-sql"],"_links":{"self":[{"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=\/wp\/v2\/posts\/720"}],"collection":[{"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=720"}],"version-history":[{"count":3,"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=\/wp\/v2\/posts\/720\/revisions"}],"predecessor-version":[{"id":721,"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=\/wp\/v2\/posts\/720\/revisions\/721"}],"wp:attachment":[{"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=720"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=720"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jonescarvalho.com\/Blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=720"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}