How to troubleshoot a failed upgrade to SQL Server 2008
- Locate the summary log file of the failed upgrade. Typically, the summary log file is located in the following folder:%ProgramFiles%\Microsoft SQL Server\100\Setup Bootstrap\LOG\The name of the summary log file resembles the following name:Summary_Server_Name-Node1_Date_Time.txt
- Open the summary log file, and then locate the Final Result entry. This entry specifies the actions that you must take to complete the upgrade. For example, you may see an entry that resembles the following entry:SQL Server upgrade failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server using the following command line, and then rerun SQL Server Setup. Uninstall command line:
setup /q /action=uninstall /instanceid=CLUSTER1 /features=SQLEngine,Replication,FullText
- Investigate and resolve the problem that caused the failure. Then, continue with the remaining steps.
- At the command prompt, move to the following folder:%Program Files%\Microsoft SQL Server\100\Setup Bootstrap
- At the command prompt, type the command that you identified in the Final Result entry in step 2, and then press ENTER. For example, if the Final Result entry resembles the example entry in step 2, type the following command, and then press ENTER:setup /q /action=uninstall /instanceid=CLUSTER1 /features=SQLEngine,Replication,FullText
- After the unistallation is complete, restart the upgrade to SQL Server 2008.
Article ID: 955399 - Last Review: 03/19/2009 22:25:35 - Revision: 3.0
- sql2008relnotereadfirst sql2008relnoteupgrade sql2008relnoteinstallation sql2008relnoteconfiguration sql2008relnote kbtshoot kberrmsg kbprb KB955399