SQL Express 2008 / SQL Express 2008 restore issue

Hi There -

Just to preface this question before I write out this question, I am not a SQL guy, never have been and never will be.  

We are an IT Consulting firm that provides RMM services to small businesses and are able to hold our own on technical issues until it involves SQL or Oracle databases.  Our problem is with a messy migration of BCM 2007 to MS CRM Dynamics 2013 with a client that we got dragged into as the client trusts us and not the CRM vendor they canned.  We have got very close to the final cut-over of importing the data from BCM into CRM and we are stuck at this last piece.

We are getting the error we have attached as a .jpg to this question.  On the same server (Windows Server 2008 R2 Standard Edition) we have a copy of SQL Express 2008 (10.00.2531) and a copy of SQL Express 2008 R2 (10.50.4000).  We had been successful in our sandbox server to be able to get the BCM database upgraded from 2007 to 2010 and then we used the BCM 2010 Database Tool to run a backup with the hope  of just simply restoring it to another sandbox PC that was running BCM 2010 and then migrate more easily to CRM 2013 per a White Paper we tracked down.  My thought process on this was to install the SQL Express 2008 R2 on the same machine running SQL Express 2008 and then use the newer version of R2 to do my restore in.  That is when I get this error message  (see attached) and I was literally hoping that I could just open the DB in 10.50.4000 that I just installed and it would be done.

I think that covers what we are doing and if you have ANY questions or advice, please help.

Thanks in advance.

Sincerely,

Mike
SQL-Error.jpg
dataflownetworksAsked:
Who is Participating?
 
plusone3055Commented:
good evening
I dont want to beat around hte bush here so I'll flat out tell you
you cannot accomplish what you are trying to do..

In laymens terms your trying to put a 2015  engine in a 1965 model
you cannot restore a newer version database to an older version of SQL

As you have told us how you "never have or wil be a SQL person"
(HATER)  :)
here is your only option without getting SQL ninja on you.

the backup is on version 10.5.4000
whereever you want it to restore too needs to match or be a HIGHER version

Sorry :(
0
 
dataflownetworksAuthor Commented:
How about, how can I use Management Studio to view the v10.50 server we installed and not the v10.00.  So we are trying to get the BCM 2010 to look at the v10.50 version and not the v10.00 that opens every time we open Management Studio.  Does that make sense at all.  Thanks for your help and not going ninja on me.
0
 
arnoldCommented:
What plusone3055 said is correct. However, you simply made the wrong choice on where to restore the backup.  You need to restore the backup either on your sql server 2008 R2 standard instance or in your sql server 2008 R2 express both of which your question says is installed on this server.

A restore should follow the login transfer (you should transfer logins from the original server to the one where you will be restoring the DB because security parameters for access to the database are referencing sql server logins.)

The following is a link to the stored procedures.
http://support.microsoft.com/kb/918992/

Using ssms(express) or the one that the standard version includes will let you
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
arnoldCommented:
What are the installed instances? Each time you installed, you had to choose an instance name. Look at each sql server configuration tool to ... Look at services.msc for sql entries that are running.....
0
 
Nakul VachhrajaniTechnical Architect, Capgemini IndiaCommented:
Just upgrade your SQL Server 2008 R2 instance to the lastest Service Pack level. Here's where you can get the latest Service Pack for SQL Server 2008 R2 http://support.microsoft.com/kb/2527041

Unless you have any features that don't work on the Express edition, upgrading to the latest service pack should be sufficient.

10.50.2531 is SQL Server 2008 R2 SP1 with a CU (not sure about the CU#). 10.50.4000 is SP2. Here's where you can get version # v/s patch level information: http://support.microsoft.com/kb/321185
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
You are trying to downgrade the database version and you can't do it directly, ie, using the lower product version to restore a database from an higher product version.
In SQL Server Management Studio you have a feature called Copy Database Wizard that allows you to make a copy from an higher version database or even from Oracle but I'm don't know if that feature is available for Express Edition.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.