Informations about matinenance plans
-
Hello everyone,
I try to find how I can know which databases are included in a specific maintenance plan.
It was easy on SQL Server 2000 but seems to be more hidden on SQL Server 2005.
The only view I found is sysmaintplan_plans.
Any clue on that?
Regards.
Carl
-
Check sysdbmaintplan_databases and sysdbmaintplans table and view..
You may need to write a query join the tables and views to get all info you need...
MohammedU
Microsoft SQL Server MVP -
Hello Mohammed,
these views "preserve information for instances ugraded from a previous version of Microsoft SQL Server" (from BOL).
select * from dbo.sysdbmaintplan_databases
Returns nothing (0 rows) and...
select * from dbo.sysdbmaintplans
Returns one row that does not give me something I could use to track databases involved in my maintenance plan.
I read somewhere on internet that maintenance plans on SQL Server 2005 were now stored as SSIS packages.
Maintenance plans in SQL Server 2005 for me are a big weakness. It was a lot more easier to manager in SQL Server 2000.
Just to add a database to a Maintenance plan is now a hard job of clicking on each step of the plan to add a the name of the new database. Really a pain compare to SQL Server 2000.
Adding to that the fact that we cannot query views to obtain information about these Maintenance plan...
Regards.
Carl
-
Yes your right...I totally forgot
Creating the maintenace plan is not that hard... you can do from SSMS also without opening ssis project..
Use MP wizard...
MohammedU
Microsoft SQL Server MVP -
My complain is not about creating a maintenance plan but maintaining it
.We can have more than one hundred databases on a server.
We may need to add a database to a maintenance plan every week.
Also we based our recovery plan on the fact that we can always know which database is included in a complete backup plan.
Thanks again Mohammed.
Carl
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply