SQL Restore failing on FileStream data

Technote (troubleshooting)


32-bit SQL Restore is terminating abnormally with an insufficient memory error. The ndf and ldf files are restored and the failure occurs while processing the FileStream data.


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


The SQL Server normally starts with only 256MB of memory available for processes outside the memory pool, ie, for extended procedures or automation, etc.


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 would allow 512MB of memory, instead of the default 256MB of memory, that could be used for managing the FileStream data

Product Alias/Synonym


Document information

More support for:

Tivoli Storage Manager for Databases
Data Protection for MS SQL

Software version:


Operating system(s):


Reference #:


Modified date:


Translate my page

Content navigation