以管理员方式启动CMD
SQL code
停止sql server服务 net stop mssqlserver
启动sql server服务,加上-m -f 参数启动 net start mssqlserver /m /f
cmd->sqlcmd -E
EXEC sp_configure 'max server memory (MB)',2147483647;
GO
EXEC RECONFIGURE WITH OVERRIDE;
GO
停止sql server服务 net stop mssqlserver
启动sql server服务,net start mssqlserver