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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Maintenance Plan
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ggarza75
Yak Posting Veteran

USA
50 Posts

Posted - 03/01/2010 :  13:53:16  Show Profile  Reply with Quote
My team is about to install SQL 2008 on new servers. We're currently running SQL 2000 and all the databases will backed up and restored on the SQL 2008 servers. We're not doing any kind of migratings. Our databases are not complex enough to do a migration.

However, we do want to migrate our Maintenance Plans from SQL 2000 to SQL 2008. Is there a way to export the Plans from 2000 and then import them to 2008?

Thanks.

russell
Pyro-ma-ni-yak

USA
5072 Posts

Posted - 03/01/2010 :  15:00:41  Show Profile  Visit russell's Homepage  Reply with Quote
only way i know is to restore msdb from other server. and i've never tried that...how many maint plans do you have?
Go to Top of Page

ggarza75
Yak Posting Veteran

USA
50 Posts

Posted - 03/01/2010 :  15:04:15  Show Profile  Reply with Quote
We only have about ten. If it was up to me, I rather create them from scratch instead of trying to figure out how ot migrate them. However, my manager wants me to migrate/import them into SQL2K8.
Go to Top of Page
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000