{"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 & restore using script.sql"},"content":{"rendered":"

MSSQL has the function called backup & restore, which is useful. It works fine between different versions.<\/p>\n

But, if you need to restore from script.sql, you can do it on command line.<\/p>\n

sqlcmd -S <server> -i C:\\<your file here>.sql -o<\/code><\/pre>\n
Full explanation :\u00a0Link\u00a0<\/a><\/p>\n
and Sometimes connection string can be tricky.<\/p>\n
You can get full help from\u00a0here<\/a>.<\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
MSSQL has the function called backup & 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 <server> -i C:\\<your file here>.sql -o Full explanation :\u00a0Link\u00a0 and Sometimes connection string can be tricky. You can get full help… Continue reading MSSQL backup & 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":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t