restore database (version conflict)

I am trying to restore a database from a . bak file

When i do so i get a message telling me that the previous database was backed up on a server using 10.50 and that this version(mine) is running 10.00.44

I don't mind upgrading but i need to know what i need to upgrade to. If somebody could tell me what I need and provide a link for upgrade i would appreciate it.
vbnetcoderAsked:
Who is Participating?
 
jerrypdConnect With a Mentor Commented:
i have to believe then that the database engine is NOT at 10.50.
It sounds like the sql management interface is at that level, but not the instance itself.
somehow you need to get the INSTANCE upgraded to the correct version... I am not sure how to do that...

0
 
jerrypdCommented:
10.50 is SQL Server 2008 R2
10.00 is SQL Server 2008 (Not R2).
0
 
vbnetcoderAuthor Commented:
i am trying to upgrade to R2 without sucess
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
jerrypdCommented:
what errors are you getting?
0
 
vbnetcoderAuthor Commented:
In SQL server management studio I go to Help and about and the SQL Server Management studio version is  10.50.1600.1 --->> but when i conect to my server it shows next to the names instance name (10.0.4000)

And, I still can't import
0
 
jerrypdCommented:
when you import, are you importing into an existing database or creating a new database?
It sounds as if you are attempting to upgrade an existing database.
Can you import the database into a new (temporary) database?
0
 
vbnetcoderAuthor Commented:
I was trying to create a new database at first, but I tried your suggestion and I still have the same problem.
0
 
vbnetcoderAuthor Commented:
Yeah, me either.  I am a little confused on this one...
0
 
vbnetcoderAuthor Commented:
I created a new instance and now I am up and running...
0
 
vbnetcoderAuthor Commented:
ty
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.