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
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!