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

  • September 10, 2013 at 11:27 pm

    #1649100

    Thanks for your reply...

    when i am executing sp_delete_backuphistory '08/31/2013' its taking too long time to execute and MSDB log file is increasing very huge during this time.

    why log file size is increasing, initially its was 700 MB only after start to execute the query it was 25GB then i stop this process.

    How to over come this issue.

    Thanks.

    Pradeep