Solved

SQL SERVER RESTORE OLD BACKUP VERSIONS

Posted on 2014-02-04
3
1,848 Views
Last Modified: 2014-02-04
Hi All
I need to migrate a sql server db from 2008 to sql express. When I try to restore it via management studio I get the following error. Is there a simple massage of this sql file, or if not. please advise correct procedure.
thanks

System.Data.SqlClient.SqlError: 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)
0
Comment
Question by:COACHMAN99
3 Comments
 
LVL 25

Accepted Solution

by:
Lee Savidge earned 400 total points
Comment Utility
This database was backed up on SQL 2000, which is 8.00.2039

See here for versions: http://sqlserverbuilds.blogspot.co.uk/

You won't be able to do that. The SQL 2000 database must be upgraded to at least 2005, maybe even 2008, before you can restore it to SQL 2012 which is what you appear to be trying to do.
0
 
LVL 39

Assisted Solution

by:lcohan
lcohan earned 100 total points
Comment Utility
Are you sure that is a "2008" backup? Looks more like a SQL 2000 and "You will be not able to migrate from SQL 2000 to 2012 directly. Migration from 2000 to 2012 requires an intermediate step.

SQL Server 2012 supports upgrade from only the following versions: SQL 2005 SP4 or SQL 2008 SP2 or SQL 2008 R2 SP1."

see more details below:

http://blogs.technet.com/b/mdegre/archive/2012/06/15/migration-sql-server-2000-to-sql-server-2012.aspx
0
 
LVL 7

Author Closing Comment

by:COACHMAN99
Comment Utility
thanks guys.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
STDEVP in SQL 2 33
sQL pivot 9 39
XML to SQL Table using c# 5 44
Insert from Stored Procedure where some field/s > 0 7 32
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, Just open a new email message.  In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now