Trying to restore from .bak file old version to new

sql sql-server database-restore
Meesh picture Meesh · Mar 31, 2013 · Viewed 11.5k times · Source

The database was backed up on a server running version 8.00.2039. That version is incompatible with this server, which is running version 11.00.2100. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.SmoExtended)

I am trying to restore and I get this message.. is there anyway to restore this backup without having to install SQL Server 2005?

Answer

marc_s picture marc_s · Mar 31, 2013

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, 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.

There are tons of blog posts on this topic, e.g.

Related questions

Restoring a database from .bak file on another machine

I've not done much SQL and am still pretty new to this, so please excuse what's probably a basic question. I've been asked to look into creating an SQL job to backup our databases, store the .baks on another machine …

Read More
Restore SQL Server DB direct from another DB

How can I restore a live database without taking its backup first? We can do this from SQL Server Management Studio, but I want to do this with script, which i can run as a scheduled job.

Read More
How do I UPDATE from a SELECT in SQL Server?

In SQL Server, it is possible to insert rows into a table with an INSERT.. SELECT statement: INSERT INTO Table (col1, col2, col3) SELECT col1, col2, col3 FROM other_table WHERE sql = 'cool' Is it also possible to update a …

Read More