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

  • pradeep.mohan (9/10/2013)


    backupfile - 44095724

    backupfilegroup - 22047863

    restorefile - 974

    restorefilegroup - 487

    restorehistory - 487

    backupmediafamily - 22047869

    There is your problem. You have LOADS of backup history. The GUI is trying to read those tables and you don't have enough memory. You can cleanup old history using sp_delete_backuphistory.

    http://technet.microsoft.com/en-us/library/ms188328.aspx

    The SQL Guy @ blogspot[/url]

    @SeanPearceSQL

    About Me[/url]