Tuesday, March 20, 2012

Save SQL 2000 DB Maintenance Plans

I have some DB maintenance plans on a SQL 2000 server. This server will be
replaced. How can I save the DB maintenance plans and then recreate to the
new server ?
JTJohnny
SQL Server stores the MP in MSDB database (sysdbmaintplans is one of many)
"Johnny" <Johnny@.discussions.microsoft.com> wrote in message
news:8E500D1B-706F-4742-96FC-40FE97CD0DBD@.microsoft.com...
>I have some DB maintenance plans on a SQL 2000 server. This server will be
> replaced. How can I save the DB maintenance plans and then recreate to
> the
> new server ?
> JT

No comments:

Post a Comment