• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 3434
  • 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
1 Solution
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
How much RAM do you have?
Anthony PerkinsCommented:
Have you seen this:
insufficient system memory error during synchronisation
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

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