What causes 'Recovery completed for database ...' log messages? I am running an MS SQL Server Express (64-bit v11.0.2100.60) database and now and then I get problems that my connections times out when I want to connect. In the server log I can see that at that time there are log messages 'Recovery completed for database ...'.  

I did not run any datababase recovery nor was anything happened at that time (Windows event  log and MS SQL server logs are both 'clean').



What could cause this recovery? Is there a way to prevent it?
Check the database options for AutoClose. It looks like your database is having to start up every time someone connects to it after there have been no connections. To start a database, it also involves looking for any non-checkpointed transactions in the log, which then does a recovery to get the database ready for action.

AutoClose should be OFF.