SQL Server Forums
Profile | Register | 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
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

ggarza75
Starting Member

USA
49 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
Starting Member

USA
49 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  
 New 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