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.