MSSQL backup & restore using script.sql

In DB Tags #mssql Published 7/22/2012

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 : Link  and Sometimes connection string can be tricky. You can get full help from here.  

Leave a comment

Please note that we won't show your email to others, or use it for sending unwanted emails. We will only use it to render your Gravatar image and to validate you as a real person.