Post reply

Copy SSMS Maintenance Plans from SQL Server 2005

  • March 16, 2010 at 11:04 am

    #216674

    Hi Folks

    i am just starting to look into SQL Server 2008 even though I have not mastered SQL Server 2005, so my first question is: is there a way to copy over my Maintenance Plans from my SQL Server 2005 server to my SQL Server 2008 server ?

    Thanks

    Jim

  • March 17, 2010 at 9:39 pm

    #1135691

    If its an upgrade, it will come up in the upgrade plan and the maintenance plans will be upgraded too.

  • March 18, 2010 at 12:34 pm

    #1136211

    Hi Folks

    not an upgrade

    a fresh install on a new server

    Jim

  • March 18, 2010 at 12:44 pm

    #1136220

    Did you try exporting SSIS packages by connecting to Integration Services on SSMS to file? and do import on the destination server from the file.

    EnjoY!

  • March 18, 2010 at 12:57 pm

    #1136233

    will give it a try

    thanks

    jim

  • March 19, 2010 at 4:58 am

    #1136591

    JC-3113 (3/16/2010)

    ...is there a way to copy over my Maintenance Plans from my SQL Server 2005 server to my SQL Server 2008 server?

    Connect to Integration Services using SSMS. In the Object Explorer, expand Stored Packages. The plans are stored under msdb/maintenance plans. Right-click on each package there are choose Export.

    Paul White
    SQLPerformance.com
    SQLkiwi blog
    @SQL_Kiwi

  • March 22, 2010 at 3:14 pm

    #1137868

    Thanks Paul

    Jim

Viewing 7 posts - 1 through 6 (of 6 total)

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