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