Post reply

Insufficient Memory to run this query

  • 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

  • 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

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply