When i am doing right click database >> Task >> restore >>database. I am getting below error
"Exception of type 'system.outofmemoryexception' was thrown"
Server configuration :
32 GB RAM
64 bit O/S
2 processors
Intel(R) Xeon(R) E5620 @2.40GHZ
service pack 2
SQL server 2008R2 (Standard Edition)
Note: In that server over all 850 databases which around 120 GB. And log shipping configured around 750 databases.
Error screenshot attached for ref.
thanks,
Pradeep