Troubleshooting: Backup Error - Backup Failed. Database Error found. Unknown Sql Exception (Number = 82, Message = There is insufficient memory available in the buffer pool.)

Question: When I try to backup, system prompted error ‘Backup Failed. Database Error found. Unknown Sql Exception (Number = 82, Message = There is insufficient memory available in the buffer pool…)

Version: 1.8 / 1.9 / 2.0

Insufficient memory.png


Insufficient memory1.png


Possible Reason :

Your SQL Server instance is under memory pressure and there is no enough memory available to allocate further to buffer pool or buffer pool is restricted to not use memory beyond a certain limit.


Solution (1):

Go to Windows Start and search for Services, find your SQL Server Instance and Restart the service.

Insufficient memory2.png


Solution (2):

Try to increase more memory to SQL Server system and modify max server memory in SQL Server accordingly.
If you are running multiple instances of the Database Engine, you may set the minimum and maximum server memory to control memory usage.

You may refer to the below documentation for SQL Server memory information.

https://docs.microsoft.com/en-us/sql/database-engine/configure-windows/server-memory-server-configuration-options?view=sql-server-ver15#max_server_memory


By: Christine 211213, Lay Swan 211227, P211229


Go to menu

  AutoCount Accounting 2.0


  AutoCount Accounting 1.8 / 1.9
  AutoCount Payroll
  AutoCount POS


  AutoCount On The Go
  AutoCount Accounting Plug-In Documentations