locked
How to restore an Old Database from an Older version of SQL Server to a Newer version of SQL Server? RRS feed

  • Question

  • How to restore an Old Database from an Older version of SQL Server (version 8.00.xxxx) to a Newer version of SQL Server (version 12.00.xxxx)?
    Monday, December 5, 2016 11:35 PM

All replies

  • To go from SQL Server 2000 (version 8.00) to SQL Server 2014 (12.00) does not have a direct upgrade path.

    You need to do an intermediate step to upgrade to SQL Server 2008 or 2008R2 (10.xx) by restoring the database to a SQL Server 2008/R2 instance.  You will see the upgrade steps logged in the Error Log. After this you can take a fresh backup and then restore this to the SQL Server 2014 instance.


    Martin Cairney SQL Server MVP

    • Proposed as answer by Olaf HelperMVP Tuesday, December 6, 2016 4:56 AM
    Tuesday, December 6, 2016 12:04 AM
  • Hello,

    The following document has all the information you need before proceeding with that kind of upgrade:

    http://download.microsoft.com/download/7/1/5/715BDFA7-51B6-4D7B-AF17-61E78C7E538F/SQL_Server_2014_Upgrade_technical_guide.pdf

    Start on page 28.



    Hope this helps.



    Regards,

    Alberto Morillo
    SQLCoffee.com


    Tuesday, December 6, 2016 12:42 AM
  • Just take the backup file, copy it to the SQL 2008 server and restore it. SQL Server will upgrade the database for you automatically. and then backup the database again and copy the backup file to SQL Server (version 8.00.xxxx)  and restore it.
    Tuesday, December 6, 2016 5:04 AM