Wolf
asked on
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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks, this wored
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.