Monday, March 12, 2012

Repeated "starting up database" in SQL Server log

I am seeing this in my SQL server logs.
Starting up database 'myDatabase'.
Starting up database 'myDatabase'.
Starting up database 'myDatabase'.
Starting up database 'myDatabase'.
You likely have the database set to auto-close.
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
I support the Professional Association for SQL Server
www.sqlpass.org
"Prabhash Shrestha" <Prabhash Shrestha@.discussions.microsoft.com> wrote in
message news:F267E7FA-DFF9-4BCD-BC7D-7D4B9647827A@.microsoft.com...
> I am seeing this in my SQL server logs.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
>
>
>
|||Your database must be set to autoclose. It is one of the options that you
can turn on and off.
Most people will recommend that autoclose be disabled
mk:@.MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\tsq
lref.chm::/ts_aa-az_4e5h.htm
ALTER DATABASE foo SET AUTO_CLOSE OFF
Keith
"Prabhash Shrestha" <Prabhash Shrestha@.discussions.microsoft.com> wrote in
message news:F267E7FA-DFF9-4BCD-BC7D-7D4B9647827A@.microsoft.com...
> I am seeing this in my SQL server logs.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
>
>
>
|||Hi
Uncheck Auto Close option of the database
"Prabhash Shrestha" <Prabhash Shrestha@.discussions.microsoft.com> wrote in
message news:F267E7FA-DFF9-4BCD-BC7D-7D4B9647827A@.microsoft.com...
> I am seeing this in my SQL server logs.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
> Starting up database 'myDatabase'.
>
>
>

No comments:

Post a Comment