Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2002
    Posts
    9

    Question 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..

    Thanks!

  2. #2
    Join Date
    Jun 2002
    Location
    USA
    Posts
    21
    Take a Full Backup Of MSDB database and restore it. That's the simplest way.

    For more Info: See BOL .

    Hope this Helps .
    -Varad

  3. #3
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185

    As per BOL

    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.

  4. #4
    Join Date
    Feb 2002
    Posts
    9
    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..

  5. #5
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185

    Upgrade/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)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •