Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2388
  • Last Modified:

Restore SQL database from 8.0 to 11.00 ?

Hello

I have taken a backup of an existing sql database with the plan being to restore it to a new server, but with a newer version.

However, I get an error message stating that I can't restore a database with version 8.0 to version 11.0

How do I fix this?

The old server is running Windows Server 2003 and SQL 2000, while the new server is running both Server and SQL 2012

Thanks in advance

Andrew
ScreenHunter-14-Jan.-17-14.07.jpg
0
Wolf
Asked:
Wolf
1 Solution
 
Carl TawnSystems and Integration DeveloperCommented:
You can't migrate straight from 2000 to 2012, you will need to upgrade your database to 2005 or 2008 R2 as an intermediary step first.
0
 
Aaron ShiloChief Database ArchitectCommented:
hi,
as  Carl Tawn sais.

SQL Server 2012 (v11.0) doesn't support direct upgrade from SQL Server 2000 (v8.0).

You'll have to use a "in-between" step restoring your SQL Server 2000 database to a SQL Server 2005 or 2008 instance(you can download the free preview version for this process), and then do a backup from there, in order to get your .bak file into the latest database server.

There's no trick or workaround for this - that's just the way it is, and you'll have to deal with it.
0
 
WolfAuthor Commented:
Thanks, this wored
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now