Restore a SQL Server 2000 backup on SQL Server 2012

sql-server sql-server-2000 sql-server-2012
user2053420 picture user2053420 · Apr 3, 2013 · Viewed 54.3k times · Source

I have got following error message while restoring a backup from SQL Server 2000 to the latest version. I do not know the old version, now I am using SQL Server 2012 (11.0.3128.0).

The error message is:

Msg 3169, Level 16, State 1, Server FF101, Line 1
The database was backed up on a server running version 8.00.0760. That version is incompatible with this server, which is running version 11.00.3128. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.

Answer

Aaron Bertrand picture Aaron Bertrand · Apr 3, 2013

You are trying to restore a SQL Server 2000 database on SQL Server 2012. This is not supported.

You will need to restore your database on an instance of SQL Server 2005, 2008 or 2008 R2 first, then back it up from there, then restore the new backup on SQL Server 2012. Microsoft explains this here.

Related questions

How to fix the embedded text qualifier issue while exporting data to CSV flat file?

RFC 4180: RFC 4180 defines Common Format and MIME Type for Comma-Separated Values (CSV) Files. One of the requirements of the RFC 4180 is stated as below. This is the point #7 in the RFC link. If double-quotes are used to enclose fields, then …

Read More
Is there a way to persist a variable across a go?

Is there a way to persist a variable across a go? Declare @bob as varchar(50); Set @bob = 'SweetDB'; GO USE @bob --- see note below GO INSERT INTO @bob.[dbo].[ProjectVersion] ([DB_Name], [Script]) VALUES (@bob,'1.2') See this …

Read More
Add a column with a default value to an existing table in SQL Server

How can I add a column with a default value to an existing table in SQL Server 2000 / SQL Server 2005?

Read More