SQL Restore failing on FileStream data

Technote (troubleshooting)


Problem(Abstract)

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.

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

Product Alias/Synonym

TSM

Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

Tivoli Storage Manager for Databases
Data Protection for MS SQL

Software version:

5.5

Operating system(s):

Windows

Reference #:

1611493

Modified date:

2013-09-17

Translate my page

Machine Translation

Content navigation