Solved

restore database (version conflict)

Posted on 2011-02-22
10
561 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
Comment Utility
10.50 is SQL Server 2008 R2
10.00 is SQL Server 2008 (Not R2).
0
 

Author Comment

by:vbnetcoder
Comment Utility
i am trying to upgrade to R2 without sucess
0
 
LVL 9

Expert Comment

by:jerrypd
Comment Utility
what errors are you getting?
0
 

Author Comment

by:vbnetcoder
Comment Utility
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
Comment Utility
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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

Author Comment

by:vbnetcoder
Comment Utility
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
Comment Utility
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
Comment Utility
Yeah, me either.  I am a little confused on this one...
0
 

Author Comment

by:vbnetcoder
Comment Utility
I created a new instance and now I am up and running...
0
 

Author Closing Comment

by:vbnetcoder
Comment Utility
ty
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Join & Write a Comment

Hi all, It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

771 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

12 Experts available now in Live!

Get 1:1 Help Now