Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 570
  • Last Modified:

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.
0
vbnetcoder
Asked:
vbnetcoder
  • 6
  • 4
1 Solution
 
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
 
jerrypdCommented:
what errors are you getting?
0
NEW Veeam Backup for Microsoft Office 365 1.5

With Office 365, it’s your data and your responsibility to protect it. NEW Veeam Backup for Microsoft Office 365 eliminates the risk of losing access to your Office 365 data.

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

Featured Post

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

  • 6
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now