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.
2、从SQL2000,SQL2005,SQL2008升级到SQL2008R2
重启之后
2014-3-10补充:
判断数据库是否曾经从SQL2008升级到SQL2008R2看目录
门头沟
SQL2008升级到SQL2008R2,在MSSQL10_50.MSSQLSERVER文件夹里只有Binn文件夹