Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

restore database (version conflict)

Posted on 2011-02-22
10
Medium Priority
?
568 Views
Last Modified: 2012-05-11
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
Comment
Question by:vbnetcoder
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 4
10 Comments
 
LVL 9

Expert Comment

by:jerrypd
ID: 34951985
10.50 is SQL Server 2008 R2
10.00 is SQL Server 2008 (Not R2).
0
 

Author Comment

by:vbnetcoder
ID: 34952002
i am trying to upgrade to R2 without sucess
0
 
LVL 9

Expert Comment

by:jerrypd
ID: 34952879
what errors are you getting?
0
Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

 

Author Comment

by:vbnetcoder
ID: 34953676
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
 
LVL 9

Expert Comment

by:jerrypd
ID: 34953897
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
 

Author Comment

by:vbnetcoder
ID: 34953989
I was trying to create a new database at first, but I tried your suggestion and I still have the same problem.
0
 
LVL 9

Accepted Solution

by:
jerrypd earned 2000 total points
ID: 34954816
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
 

Author Comment

by:vbnetcoder
ID: 34954827
Yeah, me either.  I am a little confused on this one...
0
 

Author Comment

by:vbnetcoder
ID: 34955752
I created a new instance and now I am up and running...
0
 

Author Closing Comment

by:vbnetcoder
ID: 34955755
ty
0

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question