Solved

sql server 2008 install issues

Posted on 2013-01-04
4
327 Views
Last Modified: 2013-01-04
I am having fits trying to install this on my windows 7 machine.  It is a 64 bit operating system.  Now that I have it installed I can't attach a database.  One thing after another.  I get the error on the attached file.  Any help would be much appreciated.
sql--server-error.docx
0
Comment
Question by:Bob Schneider
  • 2
4 Comments
 
LVL 22

Accepted Solution

by:
Steve Wales earned 167 total points
ID: 38745932
It appears you are trying to attach a database from SQL Server 2008 R2 to SQL Server 2008.  While both databases are called "2008" you can't do that.

See:
http://social.msdn.microsoft.com/Forums/sa/sqldatabaseengine/thread/99c427f6-8d78-45de-953d-c6dd67ee4dae
http://stackoverflow.com/questions/12151705/cannot-be-opened-because-it-is-version-661

If you want the data, I would suggest something like the import / export wizard (I believe that will work)
0
 
LVL 2

Assisted Solution

by:MaxEL_UA
MaxEL_UA earned 333 total points
ID: 38745940
On the attached screen error is described - you try to attach newer DB file to older database.
Try to update your installation to most recent version and then attach DB. DB upgrade must be proceed without problems
0
 
LVL 2

Assisted Solution

by:MaxEL_UA
MaxEL_UA earned 333 total points
ID: 38745946
"actual version" is means that all SP must be installed
SPs - Are very important !!!

I've moved databases on regular basis from previous version to actual versions without any problems till 8 years. All of DB Engines have been actual updates installed.
0
 

Author Closing Comment

by:Bob Schneider
ID: 38745970
Very nice discussion...
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Join & Write a Comment

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.
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.
This Micro Tutorial will give you a basic overview of Windows Live Photo Gallery and show you various editing filters and touches to photos you can apply. This will be demonstrated using Windows Live Photo Gallery on Windows 7 operating system.

744 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

14 Experts available now in Live!

Get 1:1 Help Now