Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2002
    Posts
    1

    Unanswered: Migrating SQL2000 DB to SQL2005

    Any one knows if I can restore a SQL2000 database backup file on SQL2005? and the DB structure will be upgraded?
    Many thanks.

  2. #2
    Join Date
    Jul 2002
    Location
    Luxembourg
    Posts
    6

    Restoring SS2K onto a SS2K5 DB server

    hcsiu,
    I've not done this since the CTP release (pre-retail), but yes, you definitely could do it with a backup from SQL Server 2000 SP4. What changes it makes to the structure I do not know - I'd recommend doing a side by side comparison of a SS2000 backup restored onto a test SS2005 server and note the differences.

    Jon.

  3. #3
    Join Date
    Dec 2005
    Posts
    1
    Yes you can restore a SQL2000 database backup file on SQL2005
    First time when you restore you will see message of db file conversion
    from version 8 to 9.

    I have done this and it works fine without any issues

    Kindest Regards,
    Sameer Raval [DBA-Sql Server]

Posting Permissions

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