Post reply

SQL 2000 to 2005 Migration of Maintenace Plans

  • August 18, 2011 at 3:30 am

    #246453

    How do we go about moving Maint Plans from SQL 2000 to SQL 2005 (especially if restoring msdb is not an option)?

  • August 18, 2011 at 5:20 am

    #1370042

    save them as DTS and transfer them in to sql 2005 SSIS

    ----------
    Ashish

  • August 18, 2011 at 6:30 am

    #1370070

    1. how do we save Maint Plan as dts file?

    2. Also it requires a lot of manual effort, since we have more than 70 maint Plans

    If SSIS can do that, then its also fine with me. But still, i need the way to do that from SSIS

  • August 18, 2011 at 6:45 am

    #1370080

    if you can access google then you will get this result for your search

    http://msdn.microsoft.com/en-us/library/bb153838.aspx

    ----------
    Ashish

  • August 18, 2011 at 6:52 am

    #1370085

    Thanks for the link. But in SQL 2005, when i right click

    Database Maintenance Plans in Legacy, I dont get Migrate, I have only View History.

    I am using SQL 2005 EE.

  • August 18, 2011 at 6:54 am

    #1370087

    But in SQL 2005, when i right click

    Database Maintenance Plans in Legacy, I dont get Migrate, I have only View History.

    I am using SQL 2005 EE.

    you need to connect your sql 2000 instance in sql 2005 EE, you will see sql 2000 maintenance plan in legacy

    ----------
    Ashish

  • August 18, 2011 at 7:09 am

    #1370096

    yes, tried that.. connected SQL 2000 from

    SSMS --> Management --> Legacy --right click a specific Maint Plan -->

    I have View history, delete, properties, refresh only

    Am i doing it in a wrong way?

  • August 18, 2011 at 9:30 pm

    #1370515

    have a look of this thread

    http://www.sqlservercentral.com/Forums/Topic501078-5-1.aspx

    you might get some help here.

    ----------
    Ashish

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

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