February 27, 2019 at 6:25 am
I am migrating backup jobs from one server to another. I scripted out the agent jobs but it seems to not create the maintenance plan. Not sure if I am migrating these plans correctly
February 27, 2019 at 6:30 am
The agent job is just that, a job that calls the back up plans. You need to migrate or create the backup plans themselves they won't migrate along with an agent job any more than a stored procedure called in an agent job would, how you do that will depend on what are using to do your backups.
February 27, 2019 at 6:33 am
Is there a way to migrate maintenance plans
February 27, 2019 at 8:24 am
keanyukas - Wednesday, February 27, 2019 6:33 AMIs there a way to migrate maintenance plans
Yes. Please see the following link. 😉 http://bfy.tw/MVmZ
--Jeff Moden
Change is inevitable... Change for the better is not.
February 27, 2019 at 1:02 pm
keanyukas - Wednesday, February 27, 2019 6:33 AMIs there a way to migrate maintenance plans
At one time - you could export the maintenance plans into an SSIS project, make the necessary changes - and save them to the new server. However, with all of the changes in SSMS (Visual Studio) and SSIS that method may not work correctly - and isn't worth the time and effort.
It is just as easy - and less time-consuming - to open the old maintenance plan from the old server, copy/paste everything in that subplan, paste in a new maintenance plan on the new server and fix up any issues with the tasks (e.g. reset list of databases, rebuild index options, etc...).
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply