spid51/spid53/spid54/spid51,Unknown,Starting up database 'DBName'.(数据库频繁自动启动解决方式)...

数据库日志如下：

 

 

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