Failed to initialize the Common Language Runtime (CLR) v2.0.50727 with HRESULT 0x80004005. You need to restart SQL Serve

4G 内存 32bit win2k3+sql2k8 sp1

运行一段时间后，在添加字段或修改字段长度时：

Failed to initialize the Common Language Runtime (CLR) v2.0.50727 with HRESULT 0x80004005. You need to restart SQL Server to use CLR integration features.

重启SQL Server后，error有：

AppDomain 2 (mssqlsystemresource.dbo[runtime].1) created.
AppDomain 3 (mssqlsystemresource.dbo[ddl].2) unloaded.
AppDomain 4 (mssqlsystemresource.dbo[ddl].3) unloaded.
AppDomain 5 (mssqlsystemresource.dbo[ddl].4) unloaded.
AppDomain 6 (mssqlsystemresource.dbo[ddl].5) unloaded.
AppDomain 7 (mssqlsystemresource.dbo[ddl].6) unloaded.
AppDomain 8 (mssqlsystemresource.dbo[ddl].7) unloaded.
AppDomain 9 (mssqlsystemresource.dbo[ddl].8) unloaded.
AppDomain 10 (mssqlsystemresource.dbo[ddl].9) unloaded.
AppDomain 11 (mssqlsystemresource.dbo[ddl].10) unloaded. 

 

重启后暂时可以添加字段和修改字段长度。

 

相关：

http://connect.microsoft.com/SQLServer/feedback/details/391313/clr-initialization-permanently-failed

http://support.microsoft.com/kb/2003681

http://connect.microsoft.com/SQLServer/feedback/details/499585/multiple-errors-in-the-sql-server-log