none
Restore Fails - There is insufficient system memory in resource pool 'internal' to run this query. RRS feed

  • Question

  • Hi

    I am trying to restore from a backup to a new database, and it processes for 8 hours and completes to 100%, and i get the following error.

    100 percent processed.
    Msg 3013, Level 16, State 1, Line 1
    RESTORE DATABASE is terminating abnormally.
    Msg 701, Level 17, State 123, Line 1
    There is insufficient system memory in resource pool 'internal' to run this query.

    I cannot access the database as it goes into recovery mode.

    Does anyone have any suggestions as to how I can get a successful restore from my backup and why it is failing on this.

    I'm using SQL Server 2008

    Thanks in advance.

     

    • Moved by KJian_ Monday, July 19, 2010 7:20 AM (From:SQL Server Search)
    Saturday, July 17, 2010 12:03 PM

Answers

All replies