SQL2008升级到SQL2008R2图形界面升级

SQL2008升级到SQL2008R2图形界面升级

1、开发版升级到企业版

但是报错,最后只能卸载SQL2008,全新安装SQL2008R2

报错内容

Overall summary:
  Final result:                  失败: 请查看下面的详细信息
  Exit code (Decimal):           -2068643838
  Exit facility code:            1203
  Exit error code:               2
  Exit message:                  The state of your SQL Server installation was not changed after the setup execution. Please review the summary.txt logs for further details.
  Start time:                    2014-03-05 11:41:37
  End time:                      2014-03-05 11:45:58
  Requested action:              EditionUpgrade

Machine Properties:
  Machine name:                  WIN-S5PFNPQT1I8
  Machine processor count:       24
  OS version:                    Windows Server 2008 R2
  OS service pack:               
  OS region:                     中华人民共和国
  OS language:                   中文(中华人民共和国)
  OS architecture:               x64
  Process architecture:          64 位
  OS clustered:                  否

Product features discovered:
  Product              Instance             Instance ID                    Feature                                  Language             Edition              Version         Clustered 
  Sql Server 2008      MSSQLSERVER          MSSQL10.MSSQLSERVER            数据库引擎服务                                  1033                 Enterprise Edition   10.0.1600.22    否         
  Sql Server 2008      MSSQLSERVER          MSSQL10.MSSQLSERVER            数据库引擎服务                                  2052                 Enterprise Edition   10.0.1600.22    否         
  Sql Server 2008                                                          管理工具 - 基本                                2052                 Enterprise Edition   10.0.1600.22    否         
  Sql Server 2008                                                          管理工具 - 完整                                2052                 Enterprise Edition   10.0.1600.22    否         
  Sql Server 2008                                                          客户端工具连接                                  2052                 Enterprise Edition   10.0.1600.22    否         
  Sql Server 2008                                                          客户端工具向后兼容性                               2052                 Enterprise Edition   10.0.1600.22    否         
  Sql Server 2008                                                          客户端工具 SDK                                2052                 Enterprise Edition   10.0.1600.22    否         

Package properties:
  Description:                   SQL Server Database Services 2008 R2
  ProductName:                   SQL Server 2008 R2
  Type:                          RTM
  Version:                       10
  SPLevel:                       0
  Installation location:         E:\Tools\SQL Server2008 R2\SQL Server2008 R2\x64\setup\
  Installation edition:          ENTERPRISE

用户输入设置:
  ACTION:                        EditionUpgrade
  CONFIGURATIONFILE:             C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20140305_114106\ConfigurationFile.ini
  ENU:                           False
  FARMACCOUNT:                   <>
  FARMADMINPORT:                 0
  FARMPASSWORD:                  *****
  FEATURES:                      
  HELP:                          False
  IACCEPTSQLSERVERLICENSETERMS:  False
  INDICATEPROGRESS:              False
  INSTANCENAME:                  <>
  PASSPHRASE:                    *****
  PID:                           *****
  QUIET:                         False
  QUIETSIMPLE:                   False
  UIMODE:                        Normal
  X86:                           False

  Configuration file:            C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20140305_114106\ConfigurationFile.ini

Detailed results:

Rules with failures:

Global rules:

There are no scenario-specific rules.

Rules report file:               C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\20140305_114106\SystemConfigurationCheck_Report.htm

Exception summary:
The following is an exception stack listing the exceptions in outermost to innermost order
Inner exceptions are being indented

Exception type: Microsoft.SqlServer.Setup.Chainer.Workflow.NoopWorkflowException
    Message: 
        The state of your SQL Server installation was not changed after the setup execution. Please review the summary.txt logs for further details.
View Code

 


2、从SQL2000,SQL2005,SQL2008升级到SQL2008R2

 

重启之后

 

2014-3-10补充:

判断数据库是否曾经从SQL2008升级到SQL2008R2看目录

 

门头沟

SQL2008升级到SQL2008R2,在MSSQL10_50.MSSQLSERVER文件夹里只有Binn文件夹

 

posted @ 2014-03-05 12:22  桦仔  阅读(17962)  评论(0编辑  收藏  举报