Transaction log backups fail:insufficient memory to run query

  • Juanita

    SSCertifiable

    Points: 5300

    HI.

    All of a sudden none of my transaction log backups will run from my sql agent jobs. I also tried to right clidk on the database name in enterprise manager and do ALL TASKS and backup log and no luck theire either. I get the following error:

    There is insufficient system memory to run this query.

    I was able to go into query analyzer and do run:

    BACKUP LOG dbname WITH TRUNCATE_ONLY

    and this ran fine. But when I went back to enterprise manager and try to run the backup tlog job, it abends.

    I can run database backups just fine.

    any suggestionis?

    Juanita

  • SQL ORACLE

    One Orange Chip

    Points: 27807

    Did you check whether or not any big application running on this server? Could you shrink your log file?

  • Juanita

    SSCertifiable

    Points: 5300

    HI.

    Well our technical people did some hardware work on the server last night and rebooted and voila.. all of my tlog backups are running fine.

    So I think it was a 'hardware' issue.

    But thank you for the suggestion, I never got to try it.

    Juanita

  • Peter Schofield

    Ten Centuries

    Points: 1314

    I heard it on the hearsay (ie another forum) that Microsoft advise that it is memory leakage when using linked servers. A reboot is the workaround.

  • SQL ORACLE

    One Orange Chip

    Points: 27807

    Microsoft claimed that the memory leak in linked servers is fixed in SP4.

    http://support.microsoft.com/kb/919165

  • Peter Schofield

    Ten Centuries

    Points: 1314

    Fair enough - but we have just one server (admittedly out of hundreds) where the transaction logs will suddenly stop backing up due to insufficient system memory. All our SQL2000 boxes are SP4.

  • SQL ORACLE

    One Orange Chip

    Points: 27807

    If it happens again, you may run

    sp_who2 active

    to check what process is biting the memory.

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

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