Re: DB Maintenance Plan SQL 2005 on 6300+ Database



"Erland Sommarskog" <esquel@xxxxxxxxxxxxx> wrote in message
news:Xns98FF17565805Yazorman@xxxxxxxxxxxx
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.)

And honestly I'd probably question why anyone has 6300+ databases on a
single server.

And would go further to suggest if you're really doing that, you're probably
better off writing your own tools to administer it.

It's really an edge case....



--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

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

--
Greg Moore
SQL Server DBA Consulting
Email: sql (at) greenms.com http://www.greenms.com


.

Relevant Pages

  • Re: Slow UPDATE and DELETE on SQL Server 2000
    ... databases: one on the new machine and one on the old machine (by the ... The plan from the old machine was more complex and has PARALLELISM ... > wrong with the SQL Server installation and unlikely that there are sub-system ... > linked-server driver parameters are not properly set. ...
    (microsoft.public.sqlserver.server)
  • Re: Create SQL cluster on 2003
    ... Since you are in a cluster configuration, ... Microsoft SQL Server MVP ... We only about about 20 databases - all ... Move Databases Between Computers That Are Running SQL Server ...
    (microsoft.public.sqlserver.clustering)
  • Re: Help!! Trying to migrate data from one SQL to another?!?
    ... I came up to the window on the DTS Wizard which has the option to ... I can defend myself on PL/SQL but I am not much of a SQL Server ... The application performs a replication between databases but due to ...
    (microsoft.public.sqlserver.dts)
  • Re: Side-by-side upgrade - moving master, msdb and model
    ... "In some cases, you may want to copy the system databases, including the ... from the source SQL Server 2000 instance to the SQL ... System Databases" in SQL Server 2005 Books Online to see how to do this" ... MVP - Windows Server - Clustering ...
    (microsoft.public.sqlserver.clustering)
  • Re: Side-by-side upgrade - moving master, msdb and model
    ... Microsoft SQL Server MVP ... MVP - Windows Server - Clustering ... from the source SQL Server 2000 instance to the SQL ... > 2005 instance before transferring user databases. ...
    (microsoft.public.sqlserver.clustering)