Competition: What’s your favorite Redgate tool? Enter now.

AppDomain 27 (TEST.dbo[runtime].27) is marked for unload due

jonwilkjonwilk Posts: 32
edited May 25, 2008 10:21AM in SQL Backup Previous Versions
Hi

I'm occassionally having this problem when running a scheduled incremental backup which logs the following in the event log:

AppDomain 27 (TEST.dbo[runtime].27) is marked for unload due to memory pressure.

We were running backup version 5.1.0.2781. I've just installed the latest version to see if that helps but wanted to check to see if this has been seen before?

We're running SQL Server 2005 - 9.00.2047.00 (X64) .

The problem this has is it drops any active connections on the database when it occurs.

Any ideas?

Thanks

J

Comments

  • J,

    Both SQLBackup and any CLR routines use the SQL MemToLevae memory space. SQLBackup needs at least 7Mb of contiguous memory to run. If this space is limited then either SQLBackup may fail or your CLR routines get pushed out of the memory. In SQL2005 this memory is set to 256Mb. To increase it add the -g parameter to the startup of SQL.

    We have had this problem so run with -g360 up to -g440 depending on how many database are getting backed up at the same time.

    Chris
    English DBA living in CANADA
Sign In or Register to comment.