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
Showing posts with label yukon. Show all posts
Showing posts with label yukon. Show all posts
Monday, March 12, 2012
Reusing SQL 2005 Maintenance Plans
Does anybody know of a way to move maintenance plans from one Yukon server t
o
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! ~ LindseyYou 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
o
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! ~ LindseyYou 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
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! ~ LindseyYou 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
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! ~ LindseyYou 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
Subscribe to:
Posts (Atom)