Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

SQL 2008 Upgrade Fails

Posted on 2011-03-22
8
Medium Priority
?
322 Views
Last Modified: 2012-06-27
I have attempted the upgrade from SQL 2005 SP4 Standard Edition on a Windows server 2008 box.  (Both are 32-bit.)

I got an error saying that the upgrade failed, and the error is detailed in the attached log file.  

I don't want to uninstall SQL 2005 on this box, as it is being used for production.  I simply wanted to do an in-place upgrade.

Next, I tried installing a fresh copy of SQL 2008 into a new instance.  I was going to simply restore the backups of the 2005 databases into the new 2008 instance, in order to do a side-by-side upgrade.

But, I got the same error--just on doing an install.

Somebody suggested that the only way to do a successful upgrade from SQL 2005 to 2008 is to do so by conducting an installation of SQL 2008 on a new box and migrating backups of the 2005 databases from the old server.  I have done this succesfully a lot of times, but I find it hard to believe that an upgrade of SQL 2008 requires a new box.  It looks like that is the case, from what I'm seeing, however,

Any ideas on how to get past this and on how to conduct this upgrade on this box?
Summary-KLASQLII-20110322-094615.txt
0
Comment
Question by:apitech
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 15

Expert Comment

by:Aaron Shilo
ID: 35192036
Can you post the logs from here ?
C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\<YYYYMMDD_HHMMSS>\Detail.txt
0
 
LVL 15

Expert Comment

by:Aaron Shilo
ID: 35192049
this file as well :
C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20110322_094615\sqlncli_Cpu32_1.log
0
 
LVL 1

Author Comment

by:apitech
ID: 35192097
here they are....
Detail.txt
sqlncli-Cpu32-1.log
0
Learn how to optimize MySQL for your business need

With the increasing importance of apps & networks in both business & personal interconnections, perfor. has become one of the key metrics of successful communication. This ebook is a hands-on business-case-driven guide to understanding MySQL query parameter tuning & database perf

 
LVL 15

Expert Comment

by:Aaron Shilo
ID: 35192276
hi

ok the problem i think is that you have sql client components installed on the machine.

remove all sql server components and then restart the system and reinstall.

Good luck
0
 
LVL 1

Author Comment

by:apitech
ID: 35192398
Hi Ashilo:

I have Tools, such as Management Studio, installed.  Is that what you mean by "client components"?  If not, please let me know specifically what those are.  Honestly, though, I really do not want to uninstall anything.  What if the upgrade still doesn't work?  Then, I have to scramble to reinstall and, possibly, get myself into a worse position.
0
 
LVL 15

Accepted Solution

by:
Aaron Shilo earned 2000 total points
ID: 35193830
well i suggest you try to install a new instance into a new folder.
i mean that the install directory for sql server under "program files" or what ever should be diferent than the default folder.

may be this way the shared components wont fail to install
0
 
LVL 1

Author Comment

by:apitech
ID: 35194566
Well, the client tools and those components installed/upgraded fine.  It's the database engine that won't upgrade.

Anyway, I guess this is all a moot point.  I did not have much time today to get this situation fixed.  So, the client is ordering a new server.  I'm just going to do a new install of SQL 2008 on it and migrate the SQL 2005 databases over.

Apparently, you can't do an in-place upgrade, a side-by-side upgrade, or even a new install of SQL 2008 on a box that already has SQL 2005 on it.  Uninstalling SQL 2005 likely would be the remedy, but that is not a good idea in a production environment.

Thanks, just the same, for looking into this.  I appreciate it!
0
 
LVL 1

Author Comment

by:apitech
ID: 35194751
Also, if anyone is curious, below is a link to a few people that ran into the same issue that I did and did not find a resolution.  The topic that is discussed in the beginning is the exact same issue that I ran into!

This is crazy!

http://social.msdn.microsoft.com/Forums/en/sqlsetupandupgrade/thread/814a42d0-aed4-41f5-b3c7-01eb84ce4e20

0

Featured Post

Ransomware: The New Cyber Threat & How to Stop It

This infographic explains ransomware, type of malware that blocks access to your files or your systems and holds them hostage until a ransom is paid. It also examines the different types of ransomware and explains what you can do to thwart this sinister online threat.  

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

721 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