Solved

restore database (version conflict)

Posted on 2011-02-22
10
563 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
  • 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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 

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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

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

Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

832 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