-
Title
Operating system error 0x80070002(error not found). -
Description
Operating system error 0x80070002(error not found) may be found in LiteSpeed verbose log file or the SQL Server error log. It is usually accompanied by messages similar to: Cannot open backup device VDI_0DA837A0-8832-4B96-8961-4A0AFF620456_0 AND Warning: The maxtransfer size has been correct from: 1048576 to 851968 in order to satisfy the contiguous memory available in the SQLServer process.
-
Cause
Insufficient available memory resources in SQL Server - due to memory fragmentation.
-
Resolution
SQL Servers MemToLeave areamay becomefragmented so that there is insufficient contiguous space to allocate the buffers required for the backups. Microsofts suggestion to resolving the issue is to use the start-up parameter -g with SQL Server. The -g parameter can be set in Enterprise Manager by right-clicking on the server, selecting Properties and clicking on the Start-Up parameters button at the bottom of the properties window. The default -g setting is 128Mb. It is recommended that -g256 is used, if this does not resolve the issue increase the value to -g512. Changing these settings does require SQL Server to be restarted for the changes to take affect.
NOTE: Restarting the server may also clear the memtoleave and resolve the error.
To verify the contiguous transfer size of SQL Server, run the command XP_MEMORY_SIZE from within Query Analyzer.
NOTE: SQL Server 7.0 Service Pack 2 users: The -g parameter is documented in the Readme.txt of the SQL Server 7.0 service pack, and in SQL Server 2000 Books Online. -
Additional Information