Thursday, 24 November 2011

SQL Server Jobs Migration

Suppose we are migrating a job from sql server to another through scripts. We have created the scripts and we have applied it on the second server. Jobs are created. But what about the jobs which are created through maintenance plans? It fails. By default maintenance plans will not be created by running job scripts. We have to recreate those jobs in the second server.

Thanks,

No comments:

Post a Comment