AUTOCLOSE

What does autoclose do ?
And why Starting up database message is repeated when autoclose is
true?"AMBROSE" <jeyaprabhu.j@.gmail.com> wrote in message
news:1172635162.065647.3570@.z35g2000cwz.googlegroups.com...
> What does autoclose do ?
> And why Starting up database message is repeated when autoclose is
> true?
>
If SQL Server doesn't detect usage of the said database in some interval
(can't recall what it is) it "closes" the database.
Then next time there's access, it reopens it, hence the startup up messages.
I recommend keeping autoclose turned OFF.
--
Greg Moore
SQL Server DBA Consulting
sql (at) greenms.com http://www.greenms.com|||This database option "closes" the database file whenever the last users
disconnects from the database. The resources are freed up,
but when a new user connects to the server, the database is reopened and
takes up some resources. So it is good to make this option turned
off for all databases in a production server.
Thanks
Hari
"AMBROSE" <jeyaprabhu.j@.gmail.com> wrote in message
news:1172635162.065647.3570@.z35g2000cwz.googlegroups.com...
> What does autoclose do ?
> And why Starting up database message is repeated when autoclose is
> true?
>|||On Feb 28, 9:56 am, "Hari Prasad" <hari_prasa...@.hotmail.com> wrote:
> This database option "closes" the database file whenever the last users
> disconnects from the database. The resources are freed up,
> but when a new user connects to the server, the database is reopened and
> takes up some resources. So it is good to make this option turned
> off for all databases in a production server.
> Thanks
> Hari
> "AMBROSE" <jeyaprabh...@.gmail.com> wrote in message
> news:1172635162.065647.3570@.z35g2000cwz.googlegroups.com...
> > What does autoclose do ?
> > And why Starting up database message is repeated when autoclose is
> > true?
Will autoclose option set to true create any login problem?|||> Will autoclose option set to true create any login problem?
It shouldn't and I haven't heard of such.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"AMBROSE" <jeyaprabhu.j@.gmail.com> wrote in message
news:1172639991.878459.94420@.h3g2000cwc.googlegroups.com...
> On Feb 28, 9:56 am, "Hari Prasad" <hari_prasa...@.hotmail.com> wrote:
>> This database option "closes" the database file whenever the last users
>> disconnects from the database. The resources are freed up,
>> but when a new user connects to the server, the database is reopened and
>> takes up some resources. So it is good to make this option turned
>> off for all databases in a production server.
>> Thanks
>> Hari
>> "AMBROSE" <jeyaprabh...@.gmail.com> wrote in message
>> news:1172635162.065647.3570@.z35g2000cwz.googlegroups.com...
>> > What does autoclose do ?
>> > And why Starting up database message is repeated when autoclose is
>> > true?
> Will autoclose option set to true create any login problem?
>|||Hi
"AMBROSE" wrote:
> On Feb 28, 9:56 am, "Hari Prasad" <hari_prasa...@.hotmail.com> wrote:
> > This database option "closes" the database file whenever the last users
> > disconnects from the database. The resources are freed up,
> > but when a new user connects to the server, the database is reopened and
> > takes up some resources. So it is good to make this option turned
> > off for all databases in a production server.
> >
> > Thanks
> > Hari
> >
> > "AMBROSE" <jeyaprabh...@.gmail.com> wrote in message
> >
> > news:1172635162.065647.3570@.z35g2000cwz.googlegroups.com...
> >
> > > What does autoclose do ?
> >
> > > And why Starting up database message is repeated when autoclose is
> > > true?
> Will autoclose option set to true create any login problem?
>
If you have Anti-Virus software scanning your database files there can be
problems opening the database if a scan is occurring.
You may want to read http://support.microsoft.com/default.aspx/kb/309422
John|||On Feb 27, 11:19 pm, "AMBROSE" <jeyaprabh...@.gmail.com> wrote:
> Will autoclose option set to true create any login problem?
If the "default" database for a given login is "closed", and something
prevents it from being "opened", that login will fail.|||> Will autoclose option set to true create any login problem?
Sure, in addition to the other mentioned problems, if it takes a long time
to re-open the database, the login attempt may time out.
I strongly recommend NOT using autoclose.
--
Aaron Bertrand
SQL Server MVP
http://www.sqlblog.com/
http://www.aspfaq.com/5006