?
Solved

SQL 2008 upgrade error

Posted on 2011-03-03
5
Medium Priority
?
227 Views
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
0
Comment
Question by:RBG IT
  • 2
  • 2
5 Comments
 
LVL 15

Accepted Solution

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

Author Comment

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

Thanks
John
0
 
LVL 15

Expert Comment

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

Assisted Solution

by:Daniel_PL
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.
0
 

Author Closing Comment

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

Thanks for your help.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

840 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