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.


Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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 :(

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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.
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.

Using ssms(express) or the one that the standard version includes will let you
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

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.....
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
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.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.