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

Chat now with support

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

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

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
Cause

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.
Resolution

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

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title