I need to create maintenance plans on SQL 2005 without using the wizard

I have several hundred SQl installations I need to change or create a maintenance plan and i don't want to touch every box. I need the step by step process to load the tables myself.

If you want to run the maintenance from a single seat, you could create a set of maintenance tasks in Integration Services, and create multiple connections for them. If you want to have the same plan on multiple servers run from each server, I'd create an Integration Services package again and ship it to the other servers. Use (local) as the connection string, assuming the same account can access each server.

Buck Woody

http://www.buckwoody.com

|||

It sounds like you're already familiar with maintenance plans in SQL 2K5, but just in case you're not:

http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=33&rl=1

Again, if you're a pro on this, my apologies.

Buck Woody

|||Thanks! Thought about the distribution of a services package but that doesn't initilize the maintenance folder in th SQL Enterprise tree. I know that sounds trivial but I got to follow standards.|||If this answers the question, you can mark it "answered". If you need anything else, just let us know!

Buck Woody|||Just in case you're interested in the process, you can import and export you maintenance plans. You can right click on one of your maintenance plans and then select import or export. Export from one, import to the other.

You can also "pull" your maintenance plan to another server. To do this, on the target server connect to Integration Services on the server where you created your original maintenance plan. Then go to Stored Packages - MSDB - Maintenance Plans. Right click on Maintenance Plans and then select Import.

Buck
|||Thanks