Unanswered: How migrate msdb database from SQL 7.0 to SQL 2K
Since by detaching and attaching user databases from SQL 7.0 to SQL 2K, it can be migrated but how to migrate msdb database from 7.0 to 2K since above process will not work? Any suggestion are acceptable..
The model and msdb databases can only be restored from backups created on a Microsoft® SQL Server™ 2000 server. Restore of backups of these databases made on SQL Server version 7.0 or earlier is not supported.
I think there is some difference between Upgrading the Server and Migrating the database from one server to another server.
Before migrating I think you have to apply the upgrade on Sql 7.0 and then use any migrating scheme.
May be this is of some help: