Post reply

Is there anyway to generate or copy Maintenance Plans from one Server to another

  • May 15, 2006 at 1:39 pm

    #152973

    Is there anyway to generate a Maintenance Plan Script? Or to copy a Maintenance Plan from one Server to another? I know I can generate a script for a Job, but if that Job executes a Maintenance Plan would the script contain the code to build the Maintenance Plan?

    Thanks for your assistance, Kevin

  • May 15, 2006 at 2:23 pm

    #638000

    I looked in all the obvious places for this functionality once, but never found it. I've since dabbled with SQL DMO (the object, or COM, interface for Enterprise Manager); if this functionality exists anywhere, it'd be buried in there, but I really think you--that is, all of us--are on our own here.

    Philip

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply