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

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.

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