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..
Thanks!Take a Full Backup Of MSDB database and restore it. That's the simplest way.
For more Info: See BOL .
Hope this Helps .
-Varad|||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.|||Then how can one upgrade msdb database from 7.0 to 2000 if it has hundreds of DTS packages? Is there easier method of this migration..|||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:
Upgrading Databases from SQL Server 7.0(bol)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment