Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win


SQL 2008 upgrade error

Posted on 2011-03-03
Medium Priority
Last Modified: 2012-05-11
I receive an error when upgrading a SQL instance from 2000 to 2008. "The following error has occurred: One or more command-ilne switches were invalid."
I've tried to upgrade using the 'upgrade from SQL 2000 or 2005' option in the installation media.

Screenshot attached, thanks John screenshot
Question by:RBG IT
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
  • 2
  • 2
LVL 15

Accepted Solution

Aaron Shilo earned 500 total points
ID: 35027175
could you please post the summary.log file

Author Comment

ID: 35031429
where can I find the summary.log file? I've searched for it but can't locate it.

LVL 15

Expert Comment

by:Aaron Shilo
ID: 35033912
it should be under the sql server folder in Program files
LVL 14

Assisted Solution

Daniel_PL earned 500 total points
ID: 35080311
Please look in %programfiles%\Microsoft SQL Server\100\Setup Bootstrap\Log\
In file summary.txt please find for 'error' or 'failed' messages.

Author Closing Comment

ID: 35096574
I've installed the DB on another server.

Thanks for your help.

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

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

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Recently we ran in to an issue while running some SQL jobs where we were trying to process the cubes.  We got an error saying failure stating 'NT SERVICE\SQLSERVERAGENT does not have access to Analysis Services. So this is a way to automate that wit…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
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…

618 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