As described in the link below, Express Edition enters sleep mode after being idle for some time.
http://blogs.msdn.com/b/sqlexpress/archive/2008/02/22/sql-express-behaviors-idle-time-resources-usage-auto-close-and-user-instances.aspx
And "waking up" takes some time because memory should be acquired back. But Error Log clearly indicates that although while being idle SQL Server service doesn't go down, after "waking up" databases are being recovered - like at service startup.
-- Server resumed execution after being idle 19772 seconds:...
-- Starting up database ...
-- 1 transactions rolled forward in database ...
Is there any way to force checkpoint prior to going idle thus reducing recovery time after "waking up" from idle state? Or anything else ...
Go to the complete details ...