unable to copy a database in sql 2008 R2 due to server number difference

Question

0.00/5 (No votes)

See more:

I am copying a sql2008r2 database from a laptop in a pendrive. In a desktop I have installed the same sql2008r2. In the desktop I am creating a database. Now in the desktop I use 'restore database' and select 'from device' to restore backup sets. It doesnt work and says' Compatability error- source is from 10.50.1600 and destination server is 10.0.1600'. Why this is so when I have used the same installation of sql2008r2 in both the machines? Earlier the desktop was with SQL2008. Can anyone guide?
Regards.

Posted 8-Jul-13 21:58pm

S.Rajendran from Coimbatore

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Maciej Los · Answer 1 · 2013-07-08T22:09:00

Solution 1

Please, carefuly read the message. Versions of MS SQL server on laptop and desktop computer are not the same.
Please, see this: http://www.sqlteam.com/article/sql-server-versions[^]
Update your SQL server on desktop computer and try again.

Posted 8-Jul-13 22:09pm

Maciej Los

Comments

S.Rajendran from Coimbatore 9-Jul-13 4:18am

if i use sql2010 (higher version) in desktop will it work?

Maciej Los 9-Jul-13 4:47am

You mean SQL Server 2012... I do not know 2010 official version...
If you want to provide compability between servers then upgrade ms sql server on both devices.
SQL Server 2012 Backward Compatibility[^]

Adarsh chauhan 9-Jul-13 5:17am

Hi Macial Los ..
I was not knowing that "Versions of MS SQL server on laptop and desktop computer are not the same."
Thanks for mentioning..
i would like clear my confusion,so can you tell me that do you mean "sql server 2008r2 on desktop" and "sql server 2008r2 on laptop" would not be same, even if i am installing from same setup file???
waiting for your response..
would be better if you provide any link which states little more on the same topic..

Maciej Los 9-Jul-13 5:33am

I don't think so that was the same setup file... Different versions... different setups. Follow above link to check the date of publishing.

Adarsh chauhan 9-Jul-13 5:35am

i already gone through the link.. but my question is that if i install SqlServer on desktop and laptop both using same CD. then??? it would be same version.. no???

Maciej Los 9-Jul-13 5:39am

Yes, it should be the same version. But... maybe you've done updates only on one device?

Adarsh chauhan 9-Jul-13 5:45am

hmm.. That's what i was asking... Thanks a ton... got my answer..