Posted by Erland Sommarskog on 03/25/07 22:09

neurocon (Neurocon@gmail.com) writes:
> Could you clarify "auto-close"?

Autoclose is a database setting whereby SQL Server automatically shuts
down the database when the last user leaves. Subsequently if any user
starts to performa some action in the database, SQL Server has to start
up the database again.

Auto-close is an option that rarely is useful, as it causes more problems
that what it helps. However, if you as Sven have 6300 databases on the
server, the option starts to become compelling, as each open database
takes up memory.

You can use the ALTER DATABASE command to change the auto-close setting for
a database.

As for the original question, I don't really have any good suggestion.
It's not surprising that Mgmt Studio feels compelled to visit the database.
Probably the best is to avoind Management Plans altogether, but just set
up an SQL job that performs what you want to be done. Possibly you could
create a Maintenance plan for a small number of databases, and then
work with the plan in Business Intelligence Development Studio. (It is
ab SSIS package as I understand it.)

--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]