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
2 comments:
i like this post and its very helpful to us. Thankyou For shearing This Information With Us.yatiken IT consultant
Do you know that there are best Windproof pipe lighters throughout the internet? Of course,It is hard to light the tobacco inside the channel with ordinary lighters. Nonetheless, the channel lighters have become the most significant and commendable instrument for lighting pipe.
Post a Comment