Insufficient Memory to run this query

• ankur_libra

  Hall of Fame

  Points: 3999

  More actions

  November 5, 2009 at 4:33 am

  #213419

  On MS SQL Server 2000 EE (SP4), we have 4 SQL Server instances configured. On One instance (having 18 databases) we are facing this problem:-

  A few configured scheduled backup jobs got failed in last two days with message :

  "Downgrading backup buffers from 960K to 64K"

  On checking, it was found that Full backup step got succeeded and only transactional backup step got failed.

  Now, as per suggestions on MS KB Link at

  http://support.microsoft.com/kb/904804/en-u

  I have tried to take the Transactional backup using following query, by reducing Maxtransfersize to 128KB, but failed with message "nsufficient Memory to run this query".

  backup log Dirman to disk='D:\LatestBkp\Dirman.trn'with maxtransfersize=131072

  Note: It has 19 backup devices (for Trn and BAK) defined for this instance.

  Please guide in this regard.

  With regards,

  Ankur

• ankur_libra

  Hall of Fame

  Points: 3999

  More actions

  November 6, 2009 at 11:00 am

  #1076039

  Hi,

  FYI..

  Issue got resolved on deletion of excess backup devices and then restarting the server.

  🙂

  Ankur