{"id":659,"date":"2012-07-22T17:01:30","date_gmt":"2012-07-22T07:01:30","guid":{"rendered":"http:\/\/www.moneystock.net\/wp_e\/?p=659"},"modified":"2012-07-22T17:02:00","modified_gmt":"2012-07-22T07:02:00","slug":"mssql-backup-restore","status":"publish","type":"post","link":"https:\/\/moneystock.net\/wp_e\/2012\/07\/22\/mssql-backup-restore\/","title":{"rendered":"MSSQL backup &#038; restore using script.sql"},"content":{"rendered":"<p>MSSQL has the function called backup &amp; restore, which is useful. It works fine between different versions.<\/p>\n<p>But, if you need to restore from script.sql, you can do it on command line.<\/p>\n<pre><code>sqlcmd -S &lt;server&gt; -i C:\\&lt;your file here&gt;.sql -o<\/code><\/pre>\n<p>Full explanation :\u00a0<a href=\"http:\/\/stackoverflow.com\/questions\/431913\/how-do-you-run-a-300mb-ms-sql-sql-file\" target=\"_blank\">Link\u00a0<\/a><\/p>\n<p>and Sometimes connection string can be tricky.<\/p>\n<p>You can get full help from\u00a0<a href=\"http:\/\/www.connectionstrings.com\/sql-server-2005\" target=\"_blank\">here<\/a>.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>MSSQL has the function called backup &amp; restore, which is useful. It works fine between different versions. But, if you need to restore from script.sql, you can do it on command line. sqlcmd -S &lt;server&gt; -i C:\\&lt;your file here&gt;.sql -o Full explanation :\u00a0Link\u00a0 and Sometimes connection string can be tricky. You can get full help&hellip; <a class=\"more-link\" href=\"https:\/\/moneystock.net\/wp_e\/2012\/07\/22\/mssql-backup-restore\/\">Continue reading <span class=\"screen-reader-text\">MSSQL backup &#038; restore using script.sql<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[128],"tags":[143],"class_list":["post-659","post","type-post","status-publish","format-standard","hentry","category-db","tag-mssql","entry"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/moneystock.net\/wp_e\/wp-json\/wp\/v2\/posts\/659","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/moneystock.net\/wp_e\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/moneystock.net\/wp_e\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/moneystock.net\/wp_e\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/moneystock.net\/wp_e\/wp-json\/wp\/v2\/comments?post=659"}],"version-history":[{"count":3,"href":"https:\/\/moneystock.net\/wp_e\/wp-json\/wp\/v2\/posts\/659\/revisions"}],"predecessor-version":[{"id":662,"href":"https:\/\/moneystock.net\/wp_e\/wp-json\/wp\/v2\/posts\/659\/revisions\/662"}],"wp:attachment":[{"href":"https:\/\/moneystock.net\/wp_e\/wp-json\/wp\/v2\/media?parent=659"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/moneystock.net\/wp_e\/wp-json\/wp\/v2\/categories?post=659"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/moneystock.net\/wp_e\/wp-json\/wp\/v2\/tags?post=659"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}