Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2003
    Location
    Singapore
    Posts
    200

    Unanswered: Not Enought Memory while taking Backup

    Hai all,

    While taking a backup i am facing the particular error recently.

    SQL2009C There is no enough memory available to run the utility

    As per the erro code number i checked and it say that either i may not have enough system memory or enough dbheap.I increased dbheap and have sufficient system memory.

    Still now i cannot take the backup.

    is there any other thing i can do.

    thanks in advance
    Micky

  2. #2
    Join Date
    Nov 2002
    Location
    Delaware
    Posts
    186

    Re: Not Enought Memory while taking Backup

    Make sure you have enough memory allocated to your util_heap_sz, If you run the backup with more than 1 session or more than 2 buffers, you must take the backbufsz * # of buffers * # of sessions, so if you run the following command, backup db xxx online use adsm open 2 sessions with 4 buffers parallelism 2, you would need you util_heap_sz = 4096 * 2 * 2 + 4096 . so it would need to be 20480.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •