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

From AutoCount Resource Center
Revision as of 06:30, 31 December 2021 by LaySwan (talk | contribs) (Created page with "'''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 File:Insufficient memory.png File:Insufficient memory1.png <u><b>Possible Reason :</b></u> Your SQL Server instance is under memory pressure and there is no enough memory available to allocate further to buffer pool or bu...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

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

IconAcc20.PNG AutoCount Accounting 2.0


IconAcc188.PNG AutoCount Accounting 1.8 / 1.9
Wiki-Payroll.png AutoCount Payroll
Wiki-POS.PNG AutoCount POS


Wiki-AOTG.PNG AutoCount On The Go
Wiki-Accounting-Plugin.png AutoCount Accounting Plug-In Documentations