Solved

restore database (version conflict)

Posted on 2011-02-22
10
562 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
 

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
VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

 

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
In this article I will describe the Copy Database Wizard 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.
Sending a Secure fax is easy with eFax Corporate (http://www.enterprise.efax.com). First, just open a new email message. In the To field, type your recipient's fax number @efaxsend.com. You can even send a secure international fax — just include t…
CodeTwo Sync for iCloud (http://www.codetwo.com/sync-for-icloud?sts=6554) automatically synchronizes your Outlook 2016, 2013, 2010 or 2007 folders with iCloud folders available via iCloud Control Panel. This lets you automatically sync them with…

911 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now