hi all, little suggestion. 1.Hi all, we are planning to migrate to sql 2005. Do we have to drop and recreate all the maintainance plan jobs while migrating. Thanks in advance.
Best practice is to recreate them in SQL 2005 when you are migrating the databases, using SSIS in 2005 is better than simply copying them from 2000 version.