数据库日志如下：
11/14/2011 06:25:56,spid51,Unknown,Starting up database 'DBNam'. 11/14/2011 06:14:28,spid55,Unknown,Starting up database 'DBNam'. 11/14/2011 06:09:55,spid51,Unknown,Starting up database 'DBNam'. 11/14/2011 05:49:56,spid51,Unknown,Starting up database 'DBNam'. 11/14/2011 05:35:55,spid51,Unknown,Starting up database 'DBNam'. 11/14/2011 05:32:08,spid53,Unknown,Starting up database 'DBNam'.
英文资料说明如下：
By default SQL Express databases are created as AUTO_CLOSE ON. As such, they are closed as soon as the last session releases access to it. They will auto-open on next access. AUTO_CLOSE databases run an optimized recovery when opened so their openning is not as bad as a fully fledged database open. But none-the-less, you can turn AUTO_CLOSE OFF if you wish:
执行以下语句：
ALTER DATABASE DBName SET AUTO_CLOSE OFF
转载于:https://www.cnblogs.com/caicainiao/archive/2011/11/15/2249988.html
相关资源：数据库操作语句大全(sql)