Options
AppDomain 27 (TEST.dbo[runtime].27) is marked for unload due
jonwilk
Posts: 32
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
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
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