Home Forums SQL Server 2005 Administering Getting an error "Exception of type 'System.OutOfMemoryException' was thrown." during stored procedure execution RE: Getting an error "Exception of type 'System.OutOfMemoryException' was thrown." during stored procedure execution

  • 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