Solved

Restoration of 32-bit database into 64-bit environment

Posted on 2011-03-03
3
792 Views
Last Modified: 2012-05-11
I have made a backup of a 32-bit database using Management Studio Express (ver 10.50.1600.1).

I have a new 64-bit server where SQL Express 2008 64-bit and Management Studio Express (ver 10.0.1600.22 ((SQL_PreRelease).080709-1414) is installed.

In attempting to restore the backup onto the new server. I get the following error....

System.Data.SqlClient.SqlError:  The database was backed up on a server running version 10.50.1600.  That version is incompatible with this server, which is running version 10.00.4000.  Either restore the database on a server that supports the backup, or use a backup that is compatible with this server.

Is my issue that I am initially working with SQL Express 2008 R2 and the new installation is NOT R2???

Otherwise, what's the problem?
0
Comment
Question by:TSFLLC
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 5

Expert Comment

by:OrcaKnight
ID: 35029693
To put it briefly, yes. :) The destination SQL version has to be equal to or higher than the source, unless you use an interim format, like CSV or previous version.
0
 
LVL 29

Expert Comment

by:Olaf Doschke
ID: 35029987
"and the new installation is NOT R2???" Yes, you said so. 2008 R2 is not a service pack, it's a release 2, a major new version, rather SQL Server 2010. And even thought the 2008 is a full version while your R2 is an express version only, the version is newer and you can't restore an R2 backup in an SQL2008 Server.

Steps you can do:
Create a new database in the SQL 2008 R2 Express Server and in options set it's compatibility to SQL 2008, then copy the R2 database into that database and backup the database. Then restore that backup.

Bye, Olaf.
0
 
LVL 13

Accepted Solution

by:
dwkor earned 500 total points
ID: 35030442
Olaf, you cannot achieve the downgrade with database compatibility option. This option controls SQL Server behavior, not the file format.

If you need to downgrade the database, the simplest option is to generate the script on R2 Management Studio/Database/Right mouse click/tasks/generate script) WITH "script data" option enabled and run this script on the destination 2008 server. This would not work very well if you have a lot of data - in that case you need to export/import data via wizards or bcp.

But the simplest option is to install new SQL 2008 R2 express.

PS 32 bit vs. x64 does not have anything to do with the database files/backups.
0

Featured Post

PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL / Table Lock? 7 40
Sub form showing data is being saved but cannot be displayed.. 31 66
HIghlights of SSIS? 3 42
Need split for SQL data 5 37
In this article I will describe the Copy Database Wizard 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.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.

739 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