SQL Server Performance

maintainance plan

Discussion in 'Getting Started' started by lara99, Dec 3, 2007.

  1. lara99 New Member

    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.
  2. satya Moderator

    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.

Share This Page