Solved

sql server 2008 install issues

Posted on 2013-01-04
4
332 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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

New Windows 7 Installations take days for Windows-Updates to show up and install. This can easily be fixed. I have finally decided to write an article because this seems to get asked several times a day lately. This Article and the Links apply to…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
This Micro Tutorial will teach you the basics of configuring your computer to improve its speed. It will also teach you how to disable programs that are running in the background simultaneously. This will be demonstrated using Windows 7 operating…
This Micro Tutorial will go in depth within Systems and Security in Windows 7 and will go into detail regarding Action Center, Windows Firewall, System, etc. This will be demonstrated using Windows 7 operating system.

680 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