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

 

posted @ 2011-11-15 17:36  caicainiao  阅读(809)  评论(0编辑  收藏  举报