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%20Server\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'.
>
>
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment