Solved

restore database (version conflict)

Posted on 2011-02-22
10
566 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 

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 500 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

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
How can I get the entire database script? 7 34
point in time restore in SQL server 26 54
How to keep a record with the highest value 3 59
When are cursors useful? 8 61
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…

738 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