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文件夹
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· SQL Server 2025 AI相关能力初探
· Linux系列:如何用 C#调用 C方法造成内存泄露
· AI与.NET技术实操系列(二):开始使用ML.NET
· 记一次.NET内存居高不下排查解决与启示
· 探究高空视频全景AR技术的实现原理
· 阿里最新开源QwQ-32B,效果媲美deepseek-r1满血版,部署成本又又又降低了!
· SQL Server 2025 AI相关能力初探
· 单线程的Redis速度为什么快?
· AI编程工具终极对决:字节Trae VS Cursor,谁才是开发者新宠?
· 开源Multi-agent AI智能体框架aevatar.ai,欢迎大家贡献代码
2013-03-05 SQLSERVER数据库中的5173错误