Want to work with us? We're on the lookout for digital experts.

We're hiring

insufficient memory to continue the execution of the program (mscorlib)

Web Bureau

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

Grow your businessStart a project with us today.

This site uses essential cookies for parts of the site to operate and have already been set. Find out more about how we use cookies and how you may delete them. You may delete cookies, but parts of the site will not work.