-
Título
Operating system error 0x80070008 (Not enough storage is available to process this command.) -
Descripción
Operating system error 0x80070008(Not enough storage is available to process this command.) when backing up or restoring LiteSpeed files. This error message may accompany the error message Operating system error 995(The I/O operation has been aborted because of either a thread exit or an application request.). in the LiteSpeed verbose log or the SQL Server error log (or job history).
-
Causa
The server does not have enough memory resources left in the mem-to-leave area to process the command.
-
Resolución
To assist in troubleshooting, run the following query in Query Analyzer against the master database; dbo.xp_memory_size This will indicate the amount of continuous memory on the SQL Server. SQLDIAG will also indicate the amount of memory on the server and how it is allocated, if AWE is enabled.
LiteSpeed, by default, uses 1MB MaxTransferSize and 3 Threads.
Lowering these 2 parameters will increase the chances of getting a successful Backup. (minimums are 65536 MaxTransferSize, and 1 Thread)
These parameters can ONLY be specified on the Backup however.
A Restore will use the same number of Threads and MaxTransferSize used in the backup and cannot be altered.
If you get this error during a Restore, your options are:
1) Bounce the SQL Server instance to free up the mem-to-leave fragmentation.
2) Increase the -g startup parameter thereby reserving more memory in the mem-to-leave area. (128MB if not specified, -g256 or -g512 recommended)
3) Perform another backup with lower parameters for Threads and MaxTransferSize.
-
Información adicional
SQL Server 2000 & 2005
LiteSpeed versions 4.6x, 4.7x, 4.8x