|
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,
(comments are locked)
|
|
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.
(comments are locked)
|
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.