July 20, 2012 at 3:40 am
Hi I have been having an issue for some time now with Backups failing on an instance of SQL Server 2008 R2 Enterprise Version 10.50.2500
The error message is 'There is insufficient system memory in resource pool 'default' to run this query.'
I do not believe that this error message is correect. I have been able to replicate this manually today during production (when 100s of queriers are running) on a tiny database. The databse is 24 MB. When I try to run a manual backup i get the same error message as above. I can confirm that there is no other activity against the database when trying to execute the backup. I have tried doing a manual backup of other databases (much larger) and they complete without any issues. When executing the backup query, it returns in around 2 seconds with the error.
I can shrink, take off line, detach and run queries against this database but for some reason it will not let me back it up. I know restarting SQL Server will solve this in the short term but it will just start happening again.
I found some arcticles and hot fixes on-line in relation to memory leaks in SQL Server 2008 & 2008R2 but they are for earlier versions than I am using. There are no available patches for SQL Server (according to windows update)
Does anyone know what might be causing this.
NB: The error logs contain nothing more than the error above so I don't think posting them will be any help
Thanks in advance for any help.
May 29, 2013 at 12:00 pm
Hi,
did you resolve this?
thanks.
May 29, 2013 at 2:00 pm
It seems there were various causes that could cause this to happen. It was a reported bug in 2008/R2. I would first try patching SQL Server to SP2, which should put you at verion 10.50.4000, restart then see if the problem persists.
Joie Andrew
"Since 1982"
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply