sql server 2008 install issues

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
Bob SchneiderCo-OwnerAsked:
Who is Participating?
 
Steve WalesConnect With a Mentor Senior Database AdministratorCommented:
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
 
MaxEL_UAConnect With a Mentor Commented:
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
 
MaxEL_UAConnect With a Mentor Commented:
"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
 
Bob SchneiderCo-OwnerAuthor Commented:
Very nice discussion...
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.