Technote (troubleshooting)
Problem(Abstract)
32-bit SQL Restore is terminating abnormally with an insufficient memory error. The ndf and ldf files are restored and then the failure occurs, at the very end, while processing the FileStream data.
Symptom
An exception occurred while executing a Transact-SQL statement or batch.
There is insufficient system memory in resource pool 'internal' to run this query.
RESTORE DATABASE is terminating abnormally
Cause
The SQL Server would normally start with 256MB of memory available for processes outside the memory pool, ie, for extended procedures or automation, etc.
Environment
32-bit SQL 2008 Server
Resolving the problem
If the SQL Server needs additional memory space for processing, this can be accommodated with the "-g" switch when starting the SQL Server. For example, when processing a large amount of FileStream data during a restore, it may be necessary to start the SQL Server to accommodate additional memory.
Starting the SQL Server with the -g512 parameter will specify the amount of memory in megabytes that can be used by other processing, ie, managing the FileStream data
Product Alias/Synonym
TSM
Rate this page:
Copyright and trademark information
IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.