Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Maintenance Plans

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2005-08-29 : 07:32:29
Bryan writes "Hi,
Does anyone know of a technique to copy maintenance plans from one server to another. The servers are identical in schema. Thanks for any help!
(SQL Server 2000, Windows 2003 Server, the latest service packs)
BryanC"

Thrasymachus
Constraint Violating Yak Guru

483 Posts

Posted - 2005-08-29 : 08:07:09
right click the job, go to all task, generate sql script.

====================================================
Regards,
Sean Roussy

"pimpin ain't easy, but someone has to do it" -- Pimpin Whitefolks(?)
Go to Top of Page
   

- Advertisement -