blocks|key|222566|text|使用命令行工具SQLCMD，它对内存的要求更低。它就像这样简单：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|222567|SQLCMD+-d+<database-name>+-i+filename.sql|code-block|syntax|javascript|222568|您需要有效的凭据才能访问SQL+Server实例，甚至访问数据库|222569|entityMap^0|0|0|0^^$0|@$1|2|3|4|5|6|7|K|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|L|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|M|8|@]|9|@]|A|$]]|$1|I|3|-4|5|6|7|N|8|@]|9|@]|A|$]]]|J|$]]

use the command-line tool SQLCMD which is much leaner on memory. It is as simple as:

<pre><code>SQLCMD -d &lt;database-name&gt; -i filename.sql
</code></pre>

You need valid credentials to access your SQL Server instance or even to access a database

blocks|key|219478|text|除了@user1293068的回答之外，我还需要指定实例名称。下面是我的完整语法：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|219479|sqlcmd+-S+<ComputerName>\<InstanceName>+-d+<DatabaseName>+-i+<MyScript.sql>|code-block|syntax|javascript|219480|这在Technet的Use+the+sqlcmd+Utility文章中有记录。|offset|length|219481|(请注意，您必须输入开关值"-S"，而不是"-s“。开关区分大小写。)|219482|entityMap|0|LINK|mutability|MUTABLE|url|http://technet.microsoft.com/en-us/library/ms180944.aspx^0|0|0|A|M|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|V|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|W|8|@]|9|@$I|X|J|Y|1|Z]]|A|$]]|$1|K|3|L|5|6|7|10|8|@]|9|@]|A|$]]|$1|M|3|-4|5|6|7|11|8|@]|9|@]|A|$]]]|N|$O|$5|P|Q|R|A|$S|T]]]]

Adding to @user1293068's answer, I needed to specify the instance name. Here is my full syntax:

<pre><code>sqlcmd -S &lt;ComputerName&gt;\&lt;InstanceName&gt; -d &lt;DatabaseName&gt; -i &lt;MyScript.sql&gt;
</code></pre>

This is documented on Technet's <a href="http://technet.microsoft.com/en-us/library/ms180944.aspx">Use the sqlcmd Utility</a> article.

(Note that you must enter a switch value of "-S", not "-s". The switch is case-sensitive.)

blocks|key|2873592|text|如果需要凭据|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2873593|sqlcmd+-S+<ComputerName>\<InstanceName>+-U+<username>+-P+<password>+-d+<DatabaseName>+-i+<MyScript.sql>|code-block|syntax|javascript|2873594|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

If credentials are required

<pre><code>sqlcmd -S &lt;ComputerName&gt;\&lt;InstanceName&gt; -U &lt;username&gt; -P &lt;password&gt; -d &lt;DatabaseName&gt; -i &lt;MyScript.sql&gt;
</code></pre>

blocks|key|2873507|text|您还可以尝试增加服务器属性中的最大服务器内存值。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2873508|要编辑此设置，请右键单击服务器名称并选择Properties+>+Memory选项卡。|2873509|我在SSMS+2012中尝试执行30MB+SQL脚本时遇到此错误。|offset|length|style|CODE|2873510|将值从1024MB增加到2048MB之后，我就可以运行脚本了。|2873511|entityMap^0|0|0|G|4|0|3|6|C|6|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|P|8|@$F|Q|G|R|H|I]]|9|@]|A|$]]|$1|J|3|K|5|6|7|S|8|@$F|T|G|U|H|I]|$F|V|G|W|H|I]]|9|@]|A|$]]|$1|L|3|-4|5|6|7|X|8|@]|9|@]|A|$]]]|M|$]]

You can also try increasing the Maximum Server Memory value in server properties. To edit this setting, right click on server name and select Properties > Memory tab.

I encountered this error trying to execute a <code>30MB</code> SQL script in SSMS 2012. After increasing the value from <code>1024MB</code> to <code>2048MB</code> I was able to run the script.

blocks|key|224691|text|好吧，没有一个答案足以让我的脚本成功恢复。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|224692|所以：|224693|224694|确保您的网络帐户有足够的权限来访问您要还原的SQL+Server实例和特定的数据库。|ordered-list-item|224695|如果您要还原的数据库仅仅是从生成脚本(经过修改以包括架构和数据)生成的，则最好该数据库确实存在。|224696|在管理员模式下运行命令行工具(如有必要)，例如，从开始菜单的运行中键入CMD+|224697|在命令行工具中，键入类似"SQLCMD+-d+CMS+-i+C:\Carnotaurus\Data\script.sql"的内容。其中，CMS是我要还原的数据库的名称，"C:\Carnotaurus\Data\script.sql"是由SMSS中的生成脚本生成的还原脚本的完整文件路径。|offset|length|style|CODE|224698|224699|我希望这能澄清一些缺失的步骤。|224700|entityMap^0|0|0|0|0|0|0|C|1D|1W|3|2C|W|0|0|0^^$0|@$1|2|3|4|5|6|7|W|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|X|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|E|3|F|5|G|7|Z|8|@]|9|@]|A|$]]|$1|H|3|I|5|G|7|10|8|@]|9|@]|A|$]]|$1|J|3|K|5|G|7|11|8|@]|9|@]|A|$]]|$1|L|3|M|5|G|7|12|8|@$N|13|O|14|P|Q]|$N|15|O|16|P|Q]|$N|17|O|18|P|Q]]|9|@]|A|$]]|$1|R|3|-4|5|6|7|19|8|@]|9|@]|A|$]]|$1|S|3|T|5|6|7|1A|8|@]|9|@]|A|$]]|$1|U|3|-4|5|6|7|1B|8|@]|9|@]|A|$]]]|V|$]]

Ok, none of the answers were sufficient to get my script successfully restoring.

So:

<ol>
<li>Ensure that your network account has sufficient permissions to access both SQL Server instance and the specific database you intend to restore.</li>
<li>It's best that the database you intend to restore actually exists, if it was merely generated from Generate Scripts (with modifications to include both Schema and Data)</li>
<li>Run the command-line tool in Administrator mode (if necessary), e.g., type CMD from Run on the start menu</li>
<li>In the command-line tool, type something like <code>"SQLCMD -d CMS -i C:\Carnotaurus\Data\script.sql"</code>. Here, <code>CMS</code> is the name of the database I intend to restore and <code>"C:\Carnotaurus\Data\script.sql"</code> is the full file path of the restore script that was generated by the Generate Scripts in SMSS.</li>
</ol>

I hope this clears-up a few missing steps.

blocks|key|222710|text|打开命令提示符|type|unstyled|depth|inlineStyleRanges|entityRanges|data|222711|sqlcmd+C:\Users\mycomputer\Downloads\script\yourscript.sql+-S+servername+-i+sqlcmd+-d+datebasename|222712|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

Open command Prompt
sqlcmd -S servername -i C:\Users\mycomputer\Downloads\script\yourscript.sql -d datebasename

I am using SQL Server 2008 R2, I have a script to update the DB, that script is approx
50 MB in size and contains some about 800,000 lines.

Error: 

<blockquote>
 TITLE: Microsoft SQL Server Management Studio
 
 Cannot execute script.
 
 ADDITIONAL INFORMATION:
 
 Insufficient memory to continue the execution of the program.
 (mscorlib)
</blockquote>

Can somebody please help me to run this script without getting this error?

Getting error while running 50 MB script on SQL Server 2008 R2

命令行工具

SQL Server

数据库

服务器

我正在使用SQL Server2008 R2，我有一个脚本来更新数据库，该脚本大约是50MB大小，包含大约800,000行。错误：标题: Microsoft SQL Server Management Studio无法执行脚本。其他信息：内存不足，无法继续执行程序。(mscorlib)有没有人可以帮我运行这个脚本而不出现这个错误？

问在SQL Server2008 R2上运行50 MB脚本时出现错误
EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在SQL Server2008 R2上运行50 MB脚本时出现错误EN

回答 6

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在SQL Server2008 R2上运行50 MB脚本时出现错误
EN