Restore database from sqlexpress2008 to sqlexpress2014

Question

0.00/5 (No votes)

See more:

SQL-Server-2008R2

, +

good day,

i did try to backup my database from sqlExpress2008 and restore it in sqlExpress2014. but when i perform this operation it return me with this kind of error

'Msg 3169, Level 16, State 1, Line 1
The database was backed up on a server running version 8.00.2039. That version is incompatible with this server, which is running version 12.00.2000. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.'

is there any way for me to solve this problem?

thank you very much experts.

What I have tried:

I did try to restore it using sql backup restore and using script both return me same error.

Thank you

Posted 6-Mar-16 22:51pm

JOE Heart Under Blade

Updated 6-Mar-16 23:40pm

Add a Solution

Comments

Richard Deeming 7-Mar-16 5:43am

Are you sure about that? The error message says the backup was created in v8.00.2039 - that's SQL 2000, not 2008.

SQL 2014 can only restore backups created in SQL 2005 or later.

JOE Heart Under Blade 7-Mar-16 22:22pm

tq very much for remind me about that, yeah that's true, it's a 2000. tq very much.

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)

Maciej Los · Accepted Answer · 2016-03-06T23:40:00

Solution 1

Please, check this: Can we restore SQL Server 2008R2 backup on SQL Server 2014? - Stack Overflow[^]

This might be useful too: Upgrade a Database Using Detach and Attach (Transact-SQL)[^]

Posted 6-Mar-16 23:40pm

Maciej Los

Updated 6-Mar-16 23:46pm

v2

Comments

JOE Heart Under Blade 7-Mar-16 22:23pm

tq very much bro, you always come up with a better solution every time i ask a question. take my 5 bro. tq very much.

Maciej Los 8-Mar-16 1:35am

You're very welcome.
Cheers,
Maciej