Configuration:-
Windows Server 2003 R2 32 bit
Sql Express 2008 R2
While checking for server event as a part of maintenance we a information which is occuring after every 1-10 seconds the information is Event "Starting up database DatabaseName"
We found the solution and implemnted the same.
You need to open "Sql Express Management Studio>>Database>>Properties>>Options>>Auto Close" and set it to false.
For more information on this property, please refer
http://blogs.msdn.com/b/buckwoody/archive/2009/06/24/sql-server-best-practices-autoclose-should-be-off.aspx
http://msdn.microsoft.com/en-us/library/ms135094%28SQL.90%29.aspx
Windows Server 2003 R2 32 bit
Sql Express 2008 R2
While checking for server event as a part of maintenance we a information which is occuring after every 1-10 seconds the information is Event "Starting up database DatabaseName"
We found the solution and implemnted the same.
You need to open "Sql Express Management Studio>>Database>>Properties>>Options>>Auto Close" and set it to false.
For more information on this property, please refer
http://blogs.msdn.com/b/buckwoody/archive/2009/06/24/sql-server-best-practices-autoclose-should-be-off.aspx
http://msdn.microsoft.com/en-us/library/ms135094%28SQL.90%29.aspx
