Solved

MSSQL - There is insufficient memory in the buffer pool

Posted on 2010-11-13
2
3,038 Views
Last Modified: 2012-05-10
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
Comment
Question by:frosty1
2 Comments
 
LVL 23

Expert Comment

by:Racim BOUDJAKDJI
ID: 34127546
How much RAM do you have?
0
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 500 total points
ID: 34128715
Have you seen this:
insufficient system memory error during synchronisation
http://www.red-gate.com/messageboard/viewtopic.php?p=13262#13262
0

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now