Post reply

Script maintenance plan made in ssms?

  • August 7, 2009 at 4:09 am

    #209102

    I have a maintenance plan made in sql server 2005 SSMS (graphical). Is there a way to script this into a file?

    Thanks in advance.

    Vera

  • August 10, 2009 at 11:03 am

    #1036905

    Because maintenance plans in SQL 2005 are saved as SSIS packages, you can't script the plans. You can, however, save the packages as files to make them portable.

    Greg

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

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