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
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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.....
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER