x

Maintenance Plans

is there any way to copy maintenance plan from one sql server to another sql server,

you may consider both sql servers are with same version/edition and different version/edition.

I know we can simply open both the maintenance plan and copy plans manually and paste to the another maintenance plan ...task by task, but is thre any way/script using which I can copy entire maintence plan/all tasks from one server to another!can I have your experties please.

rgds,
more ▼

asked Aug 20, 2010 at 07:47 AM in Default

pits gravatar image

pits
830 79 91 92

I haven't had a lot of luck it this, even using custom SSIS packages. Instead I use customer stored procedures combined with sp_MSforeachdb for backup and maintenance procedures.
Aug 20, 2010 at 04:53 PM Jason Cumberland
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

You can login onto Integration Service part of sql, then browse down to the stored plan and then export.

Then do the reverse on the new server to import. Make sure that there are no "original" server specifics in the imported SSIS package...

I would give it a test first before doing it in a production env.
more ▼

answered Aug 20, 2010 at 08:06 AM

sp_lock gravatar image

sp_lock
9.2k 24 28 31

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x33
x9

asked: Aug 20, 2010 at 07:47 AM

Seen: 1061 times

Last Updated: Aug 20, 2010 at 08:13 AM