Windows server freezes and SQL connectivity lost following an install of the AppAssure agent (4037480)

立即与支持人员聊天

反馈已提交

本文是否解决了您的问题？

选择评级

标题

Windows server freezes and SQL connectivity lost following an install of the AppAssure agent
说明

Following the installation of the AppAssure agent when snapshots run the following symptoms can be observed:
1) Windows OS freezes
2) SQL connectivity lost
3) SQL 9001 error codes
原因

This problem can produce when the AUTO_CLOSE option is ON in the database, which will close the database as soon as there is no connection to it and it will reopen automatically whenever a connection is established to it. This property can have a big impact in the database performance.
解决办法

Execute the below query in SQL management studio to set the AUTO_CLOSE option OFF.
-----------------------------------------
ALTER DATABASE
SET AUTO_CLOSE OFF
----------------------------------------
Note: To set the AUTO_CLOSE option OFF for all new databases, apply the above setting to 'model' database.
Refer http://msdn.microsoft.com/en-us/library/ms135094.aspx

反馈已提交

本文是否解决了您的问题？

选择评级

建议的内容

标题