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

Question

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

Answer 1

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.

Answer 2

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

Answer 3

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

Answer 4

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