August 18, 2011 at 3:30 am
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
save them as DTS and transfer them in to sql 2005 SSIS
----------
Ashish
August 18, 2011 at 6:30 am
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
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
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
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
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
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