28 November 2012 by Web Bureau
When trying to run a backup scipt greater than 50MB sql management studio sometimes reports and error similiar to 'insufficient memory to continue the execution of the program (mscorlib)'.
To overcome this we can use commands in the command prompt to run the scripts instead. Below Is an exmaple of such a script:
osql -S <SQL Server IP/Name> -d <DB Name> -E -i <sql script file path>
Please configure as below:
-S input your SQL server Instance
-d type in your database name
-E the means trusted connect .. when you use this you don’t need to use -U & -P