How can you copy the database maintenance plans from one SQL Server instance to another SQL Server instance using 2005 version. Using the Database Maintenance plans has been increased since SQL Server 2005 is released, also lot more once Microsoft fixed the issues with Service Pack2 for SQL 2005. In general you can take help of Copy Database Wizard using copy of correct SSPI packages. WHen the operation is successful then ensure you have relevant SQL 2005 client tools (SSMS) with Service pack2 in...(
read more)
Read the complete post at http://sqlserver-qa.net/blogs/tools/archive/2007/10/15/copy-db-maint-plans.aspx