Database Starting Up

I have a database which constantly saying it i starting up!!!!
2007-02-28 12:32:22.96 spid63 Starting up database 'QA_Test'.
2007-02-28 12:32:22.98 spid63 Starting up database 'QA_Test'.
2007-02-28 12:32:23.01 spid63 Starting up database 'QA_Test'.
2007-02-28 12:35:41.09 spid63 Starting up database 'QA_Test'.
Can anyone tell me why?Hello,
Looks like you have enabled AUTOCLOSE database option turned. This will
close the database files once the last user diconnects
from the QA_test database and will put an entry back while the fast user
connect to this database. I recomment you to
disable this option being this will take some resources.
Thanks
Hari
"Adam Sankey" <AdamSankey@.discussions.microsoft.com> wrote in message
news:3679887C-EFD3-4B25-B2B0-AD8C39E0A325@.microsoft.com...
>I have a database which constantly saying it i starting up!!!!
> 2007-02-28 12:32:22.96 spid63 Starting up database 'QA_Test'.
> 2007-02-28 12:32:22.98 spid63 Starting up database 'QA_Test'.
> 2007-02-28 12:32:23.01 spid63 Starting up database 'QA_Test'.
> 2007-02-28 12:35:41.09 spid63 Starting up database 'QA_Test'.
> Can anyone tell me why?
>|||"Adam Sankey" <AdamSankey@.discussions.microsoft.com> wrote in message
news:3679887C-EFD3-4B25-B2B0-AD8C39E0A325@.microsoft.com...
>I have a database which constantly saying it i starting up!!!!
> 2007-02-28 12:32:22.96 spid63 Starting up database 'QA_Test'.
> 2007-02-28 12:32:22.98 spid63 Starting up database 'QA_Test'.
> 2007-02-28 12:32:23.01 spid63 Starting up database 'QA_Test'.
> 2007-02-28 12:35:41.09 spid63 Starting up database 'QA_Test'.
> Can anyone tell me why?
>
Yes, it is set as autoclose. Disable that.
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com|||Is it set to auto close? Check this and turn it off if it is on...
MC
"Adam Sankey" <AdamSankey@.discussions.microsoft.com> wrote in message
news:3679887C-EFD3-4B25-B2B0-AD8C39E0A325@.microsoft.com...
>I have a database which constantly saying it i starting up!!!!
> 2007-02-28 12:32:22.96 spid63 Starting up database 'QA_Test'.
> 2007-02-28 12:32:22.98 spid63 Starting up database 'QA_Test'.
> 2007-02-28 12:32:23.01 spid63 Starting up database 'QA_Test'.
> 2007-02-28 12:35:41.09 spid63 Starting up database 'QA_Test'.
> Can anyone tell me why?
>|||This is because "AutoClose" is set on your database.
This makes the database engine close the database when the last user drops
the connection to the database. This is done to free up resources. This
setting is on by default on MSDE/SQL Server Express, off by default on all
other SQL Server versions.
See also this link for some thoughts on this setting:
http://www.sqlservercentral.com/columnists/sjones/autoclosefordatabases.asp
Stein Tore
"Adam Sankey" wrote:
> I have a database which constantly saying it i starting up!!!!
> 2007-02-28 12:32:22.96 spid63 Starting up database 'QA_Test'.
> 2007-02-28 12:32:22.98 spid63 Starting up database 'QA_Test'.
> 2007-02-28 12:32:23.01 spid63 Starting up database 'QA_Test'.
> 2007-02-28 12:35:41.09 spid63 Starting up database 'QA_Test'.
> Can anyone tell me why?
>