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