Solved

sql server 2008 install issues

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

You may have a outside contractor who comes in once a week or seasonal to do some work in your office but you only want to give him access to the programs and files he needs and keep privet all other documents and programs, can you do this on a loca…
While working, an annoying popup showing below will come and we cannot cancel or close it form the screen. The error message will come again and again.
This Micro Tutorial will teach you how to change your appearance and customize your Windows 7 interface to your unique preference. This will be demonstrated using Windows 7 operating system.
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.

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

24 Experts available now in Live!

Get 1:1 Help Now