Starting Up Database.

Applies to: Microsoft SQL Server 2005 Express
 

Message.


Examining the SQL Server error log of a Microsoft SQL Server 2005 Express Instance that manage SharePoint databases we found the following record repeated many times:

Date 10/2/2008 5:10:56 PM
Log SQL Server (Current - 12/8/2008 3:01:00 PM)

Source spid82

Message
Starting up database 'SharedServices1_Search_DB_780d2d71-8175-4cee-a37c-ba4de4a20620'



Cause.

In SQL Server 2005 Express databases will auto_close every 300 milliseconds, to allow databases to be handled like any other file in Windows, allowing to backup databases using XCopy command.
 

Solution.

If you do not like the amount of records Auto_close creates in SQL Server error log or you are experiencing performance degradation on your database because it is frequently accessed, then turn Auto_close off (change it to false).






References.

Understanding SQL Express behavior: Idle time resource usage, AUTO_CLOSE and User Instances.

.Send mail to webmaster@sqlcoffee.com with questions or comments about this web site.