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.
| Author |
Topic |
|
ggarza75
Yak Posting Veteran
50 Posts |
 Posted - 2010-03-01 : 13:53:16
|
| 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
5072 Posts |
Posted - 2010-03-01 : 15:00:41
|
| only way i know is to restore msdb from other server. and i've never tried that...how many maint plans do you have? |
 |
|
|
ggarza75
Yak Posting Veteran
50 Posts |
Posted - 2010-03-01 : 15:04:15
|
| 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. |
|
|
|
|
|
|
Maintenance Plan