Tuesday, November 8, 2011

Windows Event Starting up database DatabaseName

1 comment
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

1 comments:

Anjali sharma said...



i like this post and its very helpful to us. Thankyou For shearing This Information With Us.yatiken IT consultant