• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3374
  • Last Modified:

MSSQL - There is insufficient memory in the buffer pool

I am using Red Gate's data compare and am getting the following error when i try and sync.  

This software basically sync and compare MSSQL data between db's. ie Local and remove databases. I believe the issue is not with this software but with the database instances.

error occurred executing synchronization: There is insufficient memory in the buffer pool

both database that i am trying to sync are MSSQL 2008 R2
redgate.png
0
frosty1
Asked:
frosty1
1 Solution
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
How much RAM do you have?
0
 
Anthony PerkinsCommented:
Have you seen this:
insufficient system memory error during synchronisation
http://www.red-gate.com/messageboard/viewtopic.php?p=13262#13262
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now