Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Robert London
Starting Member
26 Posts |
 Posted - 2010-07-29 : 15:41:51
|
| Hi,We were running on OS server 2003 x32 Standard with SQL 2008 and backed up a large DB. When we went to recover the DB it kept failing due to the following error 'There is insufficient system memory in resource pool 'internal' to run this query'. After attempting /pae, /3gb, -g parameter fixes the DB still failed.?We then decided to upgrade the OS to server 2003 x64 Enterprise as processes were running slow prior anyway, so it made economic sense. Then re-installed SQL 2008. We have tried restoring the DB but it has gone into recovery mode.....Any suggestions on how to rectify/ fix this would be appreciated.ThanksRobert |
|
|
|
|
|
Restored DB is 'in recovery' after OS upgrade - fi