In MS SQL Server 2005, Is There A Way To Export, The Complete Maintenance Plan Of A Database As A SQL Script?

- 1 answer

Currently, if I want to output a SQL script for a table in my database, in Management Studio, I can right click and output a create script.

Is there an equivalent to output an SQL script for a database's maintenance plan?#


The company I work for has 4 servers, 3 servers and no sign of integration, each one running about 500,000 transactions a day. The original maintenance plans were undocumented and trying to create a default template maintenance plan.



You can't export them as scripts, but if your intention is to migrate them between server instances then you can import and export them as follows:

Connect to Integration Services and expand Stored Packages>MSDB>Maintenance Plans. You can then right click on the plan and select import or export