Share via

How to restore backdata file data from version 8.00.0194 to 14.00.1000?

SILS 61 Reputation points
2020-08-28T07:20:56.58+00:00

Hi
I have mssql 2017 is running. But I need to restore the backup data from mssql 2008 (8.00.0194)

Currently I do not have MSSQL 2008.

How can I restore data from old version to New version mssql server?

When restore, the error is prompt that is

"The database was backed up on a server running version 8.00.0194. That version is incompatible with this server, which is running version 14.00.1000. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.
RESTORE DATABASE is terminating abnormally. (Microsoft SQL Server, Error: 3169)"

Is there any solution?

Please advice me

Maideen

SQL Server | Other
0 comments

4 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 133.9K Reputation points MVP Volunteer Moderator
    2020-08-28T20:59:42.023+00:00

    Just to add to Tom's response a little bit. I believe that the way to go is:

    1. Install SQL 2000 (which will we a challenge, because you will need to find an OS old enough to support it.)
    2. Restore the database.
    3. Upgrade the instance to SP4.
    4. Backup the database.
    5. Install SQL 2008 and apply SP4.
    6. Restore the database.
    7. Back it up a new.
    8. Now you can restore on any version from SQL 2008 and up.

    To give you a little more hope, I should add that I am not 100 % sure that steps 1-4 are needed. I believe at least SQL 2000 SP3 is needed for an upgrade, but maybe that is only if you are upgrading the instance. So maybe SQL 2008 will accept your backup. Maybe.

    (Bear in mind that it was a long time since SQL 2000 was ruling the world, so our memories are somewhat foggy.)

    1 person found this answer helpful.
    0 comments
  2. Tom Phillips 17,786 Reputation points
    2020-08-28T15:42:44.65+00:00

    Version 8.00.0194 is the RTM version of SQL 2000, not SQL 2008. That has not been supported for many, many, many years. At the very least you are going to need to update to SQL 2000 SP4 (if you can find it) in order to restore that backup to any version of SQL Server.

    You will be better off, exporting the data and trying to import it.

    1 person found this answer helpful.
    0 comments
  3. m 4,286 Reputation points
    2020-09-01T07:02:07.01+00:00

    Hi @SILS ,

    You can try steps from ErlandSommarskog’s reply. Or try steps as next:

    1.Restore the SQL Server 2000 backup on SQL Server 2008
    2.Create a database backup on SQL Server 2008
    3.Restore the SQL Server 2008 backup on SQL Server 2008SP4
    4.Create a database backup on SQL Server 2008SP4
    5.Restore the SQL Server 2008SP4 backup on SQL Server 2017

    More information :
    converting-a-sql-server-2000-database-to-sql-server-2016,

    restore-sql-server-backup-to-a-newer-version-of-sql-server

    If the reply is helped, please do “Accept Answer”.
    BR,
    Mia

    0 comments
  4. m 4,286 Reputation points
    2020-08-28T08:49:39.843+00:00

    Hi @SILS ,

    How can I restore data from old version to New version mssql server?

    Try steps as next:

    1.Restore the SQL Server 2008 backup on SQL Server 2008SP4
    2.Create a database backup on SQL Server 2008SP4
    3.Restore the SQL Server 2008SP4 backup on SQL Server 2017

    More information:
    https://support.microsoft.com/en-us/help/4490237/fix-restoring-backup-to-sql-server-2016-and-2017-from-sql-server-2008 ,
    https://solutioncenter.apexsql.com/restore-sql-server-backup-to-a-newer-version-of-sql-server/,
    https://learn.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-2017?view=sql-server-2017#upgrades-from-earlier-versions-to-

    BR,
    Mia
    If the reply is helped, please do “Accept Answer”.--Mia

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.