How to restore mssql 2008 backup data in mssql 2017?

Question

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 27-Aug-20 21:45pm

Maideen Abdul Kader

Updated 27-Aug-20 21:57pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Sandeep Mewara · Accepted Answer · 2020-08-27T21:57:00

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.