Monday, March 12, 2012

Reusing SQL 2005 Maintenance Plans

Does anybody know of a way to move maintenance plans from one Yukon server to
another? I don't want to have to manually set them up on each server. I'd
like to be able to script it, like in SQL 2000, if possible. Thanks in
advance! ~ Lindsey
You can import and export maintenance plans. Connect to
Integration Services on the server where the maintenance
plans are located. Go to Stored Packages -> MSDB ->
Maintenance Plans. From there you can right click on
Maintenance Plans and select Import. Or if you right click
on one of your maintenance plans, you can select import or
export.
-Sue
On Tue, 31 Jan 2006 12:00:23 -0800, Resquegal
<Resquegal@.discussions.microsoft.com> wrote:

>Does anybody know of a way to move maintenance plans from one Yukon server to
>another? I don't want to have to manually set them up on each server. I'd
>like to be able to script it, like in SQL 2000, if possible. Thanks in
>advance! ~ Lindsey

No comments:

Post a Comment