Post reply

Insufficient system resource Error

  • January 12, 2012 at 12:35 am

    #253436

    Hi,

    I have a production database backup in network drive. I have copied the backup from N:\ to DEV server E:\.. we have faced an error like "Insufficient system resources exist to complete" in the middle of copy. It would be more helpful, if anybody can help on this...

    Regards

    Balaji G

  • January 12, 2012 at 2:15 am

    #1432300

    It looks like the backup file you are trying to copy is big (in GBs) and your DEV server has very less free RAM.

    You can try copying compressed backup file. It should work.

  • January 12, 2012 at 2:27 am

    #1432304

    Thanks for you reply suresh.. I have few questions like

    I believe there is no compression backup option from SQL 2000 environment.

    Is there any chances to copied straightaway?

    How much RAM will required to copy the backup from one to other place?

    Regards

    Balaji G

  • January 12, 2012 at 2:43 am

    #1432309

    balaji.ganga 68339 (1/12/2012)

    Thanks for you reply suresh.. I have few questions like

    I believe there is no compression backup option from SQL 2000 environment.

    Is there any chances to copied straightaway?

    How much RAM will required to copy the backup from one to other place?

    Regards

    Balaji G

    There are chances of copying straightway, if you stop other processes which are comsuming the server resouces.

    You can use third party utility to take compressed backup or compress the native backup file (.BAK) with any file comporession tool (like 7-Zip)

    Another option is to split the into smaller files using third party utility. Copy it. Then merge the file.

    How much RAM is required depends on the size of the file.

  • January 12, 2012 at 5:00 am

    #1432374

    Thanks for your quick response

Viewing 5 posts - 1 through 4 (of 4 total)

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