Repeating "starting up database DBtest" message in sql log

In my sql log I see the 'starting up database DBtest' repeating every few
seconds. The database seems fine and I can retreive data from tables of the
database. I've included a short clip of my log. I think something is wrong
here. Anybody have any clues. My first take is to terminate the spid65 and
see if all is well but this is a production system so I wanted to see if
anyone else has seen this before and had any suggestions.
Thanks, Edie
7/20/20051:13:27spid63Starting up database 'DBTest'.
7/20/20051:14:27backupDatabase backed up: Database: DBTest, creation
7/21/20051:13:27spid63Starting up database 'DBTest'.
7/21/20051:14:22backupDatabase backed up: Database: DBTest, creation
7/22/20051:14:19backupDatabase backed up: Database: DBTest, creation
7/23/20051:14:21backupDatabase backed up: Database: DBTest, creation
7/24/20051:14:20backupDatabase backed up: Database: DBTest, creation
7/24/200521:00:07backupDatabase backed up: Database: master, creation
7/24/200521:00:10backupDatabase backed up: Database: model, creation
7/24/200521:00:12backupDatabase backed up: Database: msdb, creation
7/25/20051:13:27spid63Starting up database 'DBTest'.
7/25/20051:14:20backupDatabase backed up: Database: DBTest, creation
7/25/200511:06:18spid65Starting up database 'DBTest'.
7/25/200511:06:18spid65Starting up database 'DBTest'.
7/25/200511:06:18spid65Starting up database 'DBTest'.
7/25/200511:06:19spid65Starting up database 'DBTest'.
7/25/200511:06:19spid65Starting up database 'DBTest'.
7/25/200511:06:19spid65Starting up database 'DBTest'.
Hi,
It seems you have enabled the database option "AUTOCLOSE". THis will close
the MDF and LDF as soon as the last user logs of the database. Again the MDF
and LDF will be opened once a user logins to the database.
How to check this option is checked:-
1. Enterprise manager -- Databases -- Select the database
2. Right click and select properties -- Choose options
3. Chek whether AUTOCLOSE option is "checked". If yes then remove it
or from Query analyzer execute the below command to turn off:-
sp_dboption <dbname>, 'autoclose', False
This will ensure that database will never closed as soon as last user logs
off.
Thanks
Hari
SQL Server MVP
"Edie Richardson" <Edie Richardson @.discussions.microsoft.com> wrote in
message news:D91B95AE-C74C-483A-9A7F-243B879A7636@.microsoft.com...
> In my sql log I see the 'starting up database DBtest' repeating every few
> seconds. The database seems fine and I can retreive data from tables of
> the
> database. I've included a short clip of my log. I think something is
> wrong
> here. Anybody have any clues. My first take is to terminate the spid65
> and
> see if all is well but this is a production system so I wanted to see if
> anyone else has seen this before and had any suggestions.
> Thanks, Edie
> 7/20/2005 1:13:27 spid63 Starting up database 'DBTest'.
> 7/20/2005 1:14:27 backup Database backed up: Database: DBTest, creation
> 7/21/2005 1:13:27 spid63 Starting up database 'DBTest'.
> 7/21/2005 1:14:22 backup Database backed up: Database: DBTest, creation
> 7/22/2005 1:14:19 backup Database backed up: Database: DBTest, creation
> 7/23/2005 1:14:21 backup Database backed up: Database: DBTest, creation
> 7/24/2005 1:14:20 backup Database backed up: Database: DBTest, creation
> 7/24/2005 21:00:07 backup Database backed up: Database: master, creation
> 7/24/2005 21:00:10 backup Database backed up: Database: model, creation
> 7/24/2005 21:00:12 backup Database backed up: Database: msdb, creation
> 7/25/2005 1:13:27 spid63 Starting up database 'DBTest'.
> 7/25/2005 1:14:20 backup Database backed up: Database: DBTest, creation
> 7/25/2005 11:06:18 spid65 Starting up database 'DBTest'.
> 7/25/2005 11:06:18 spid65 Starting up database 'DBTest'.
> 7/25/2005 11:06:18 spid65 Starting up database 'DBTest'.
> 7/25/2005 11:06:19 spid65 Starting up database 'DBTest'.
> 7/25/2005 11:06:19 spid65 Starting up database 'DBTest'.
> 7/25/2005 11:06:19 spid65 Starting up database 'DBTest'.
>
|||Switch off "Auto Close" on the DB (Database Property)
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Edie Richardson" <Edie Richardson @.discussions.microsoft.com> wrote in
message news:D91B95AE-C74C-483A-9A7F-243B879A7636@.microsoft.com...
> In my sql log I see the 'starting up database DBtest' repeating every few
> seconds. The database seems fine and I can retreive data from tables of
> the
> database. I've included a short clip of my log. I think something is
> wrong
> here. Anybody have any clues. My first take is to terminate the spid65
> and
> see if all is well but this is a production system so I wanted to see if
> anyone else has seen this before and had any suggestions.
> Thanks, Edie
> 7/20/2005 1:13:27 spid63 Starting up database 'DBTest'.
> 7/20/2005 1:14:27 backup Database backed up: Database: DBTest, creation
> 7/21/2005 1:13:27 spid63 Starting up database 'DBTest'.
> 7/21/2005 1:14:22 backup Database backed up: Database: DBTest, creation
> 7/22/2005 1:14:19 backup Database backed up: Database: DBTest, creation
> 7/23/2005 1:14:21 backup Database backed up: Database: DBTest, creation
> 7/24/2005 1:14:20 backup Database backed up: Database: DBTest, creation
> 7/24/2005 21:00:07 backup Database backed up: Database: master, creation
> 7/24/2005 21:00:10 backup Database backed up: Database: model, creation
> 7/24/2005 21:00:12 backup Database backed up: Database: msdb, creation
> 7/25/2005 1:13:27 spid63 Starting up database 'DBTest'.
> 7/25/2005 1:14:20 backup Database backed up: Database: DBTest, creation
> 7/25/2005 11:06:18 spid65 Starting up database 'DBTest'.
> 7/25/2005 11:06:18 spid65 Starting up database 'DBTest'.
> 7/25/2005 11:06:18 spid65 Starting up database 'DBTest'.
> 7/25/2005 11:06:19 spid65 Starting up database 'DBTest'.
> 7/25/2005 11:06:19 spid65 Starting up database 'DBTest'.
> 7/25/2005 11:06:19 spid65 Starting up database 'DBTest'.
>
|||thanks! The autoclose option was checked.
"Hari Prasad" wrote:

> Hi,
> It seems you have enabled the database option "AUTOCLOSE". THis will close
> the MDF and LDF as soon as the last user logs of the database. Again the MDF
> and LDF will be opened once a user logins to the database.
> How to check this option is checked:-
>
> 1. Enterprise manager -- Databases -- Select the database
> 2. Right click and select properties -- Choose options
> 3. Chek whether AUTOCLOSE option is "checked". If yes then remove it
> or from Query analyzer execute the below command to turn off:-
> sp_dboption <dbname>, 'autoclose', False
> This will ensure that database will never closed as soon as last user logs
> off.
> Thanks
> Hari
> SQL Server MVP
>
> "Edie Richardson" <Edie Richardson @.discussions.microsoft.com> wrote in
> message news:D91B95AE-C74C-483A-9A7F-243B879A7636@.microsoft.com...
>
>