Click here to Skip to main content
15,901,284 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi
Mssql 2017 is running in server.
I need to restore old data back version 2008 to version 2017?

When restoring, The error prompt

Please advice me

Thank you

Maideen

What I have tried:

Error:
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)
Posted
Updated 27-Aug-20 21:57pm

1 solution

Quote:
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.

Though message shares the case, I am not sure of it's accuracy. I say this because of Microsoft detailed documentation that states: A backup taken on SQL Server 2008 or SQL Server 2008 R2 can be restored to SQL Server 2017

Reference and steps to do: Microsoft Data Migration Guide - Upgrade SQL Server to SQL Server[^]

Try out following the article and see.

UPDATE:
Was going through and found another reference: Supported version and edition upgrades (SQL Server 2017) - SQL Server | Microsoft Docs[^]
For backward compatibility, your 2008 version has to be one of below:
- SQL Server 2008 SP4 or later
- SQL Server 2008 R2 SP3 or later

if you had other version, it would not be compatible and thus not supported.
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900