Ad

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?#

Edit

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.

Ad

Answer

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

Ad
source: stackoverflow.com
Ad