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)
 Back up a backup plan

Author  Topic 

Hommer
Aged Yak Warrior

808 Posts

Posted - 2004-09-28 : 12:04:02
Hello, everybody,

I want to know how to transfer a maintenance plan between two SQL Server instances on the same SQL2K box.

The big picture is this. The company is migrating several third party package applications to SQL server backend.

The other guys have to dump the database and reload the data from time to time. But in between, I supposed to run these plans. Instead of creating my plans from scratch every time, I want to preserve my plans by moving them to another place then bring them back after the reload.

If I am asking too much here, that is because all your experts in this forum who seem spoil the readers by having an answer for any impossible questions.

Thanks!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-09-28 : 12:15:33
I don't think this is possible. But don't use maintenance plans!

http://weblogs.sqlteam.com/tarad/archive/2004/07/02/1705.aspx

Tara
Go to Top of Page
   

- Advertisement -