升级到 SQL Server Express 2008 SP2 时出现问题

发布于 2024-11-29 07:21:05 字数 656 浏览 1 评论 0 原文

就在今天早上,我通过 Web 平台安装程序安装了 SQL Server 2008 Express SP2。当我去恢复一些数据库时,错误消息是我的数据库文件来自版本10.5,而我的版本是10.0.4000。我尝试从 Microsoft 下载此文件,但出现错误说我的机器没有任何需要升级的东西。

我运行了这段代码:

SELECT 
  SERVERPROPERTY('productversion') as 'Product Version',
  SERVERPROPERTY('productlevel') as 'Service Pack', 
  SERVERPROPERTY('edition') as 'Edition',
  SERVERPROPERTY('instancename') as 'Instance',
  SERVERPROPERTY('servername') as 'Server Name'

并得到了这个:

10.0.4000.0 SP2 Express Edition SQLEXPRESS  DEV-PC1\SQLEXPRESS

Just this morning, I installed SQL Server 2008 Express SP2 from the Web Platform Installer. When I went to restore some databases, the error message was that my database files are from version 10.5 and I have version 10.0.4000. I tried downloading this file from Microsoft, but it errored out saying that I don't have anything to upgrade in my machine.

I ran this code:

SELECT 
  SERVERPROPERTY('productversion') as 'Product Version',
  SERVERPROPERTY('productlevel') as 'Service Pack', 
  SERVERPROPERTY('edition') as 'Edition',
  SERVERPROPERTY('instancename') as 'Instance',
  SERVERPROPERTY('servername') as 'Server Name'

And got back this:

10.0.4000.0 SP2 Express Edition SQLEXPRESS  DEV-PC1\SQLEXPRESS

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(1

命比纸薄 2024-12-06 07:21:05

我相信你很好并且已经更新到最新版本,只是对术语有点困惑。顺便说一句,查找和运行该查询的工作非常棒,但很多人并没有付出这样的努力。

尽管名称相似,但 SQL Server 2008 (10.00) 和 SQL Server 2008 R2 (10.50) 是 SQL Server 产品的不同版本。 版本表示产品许可证,在您的情况下为 Express。

Service Pack(SP)是 累积更新、CU,通常还有一些小的功能修复/改进。更糟糕的是,Hot Fix 或 QFE 是一种专注于修复特定问题的软件补丁。

将版本与可用修复程序绑定的最佳列表是此站点,SQL Server 版本数据库 此时,您当前的 Service Pack 级别为“2008 + Service Pack 2”,如您的版本号所示 (10.00.4000) 自此以来已发布了 4 个累积更新然后是 SP2 和 QFE(修补 XML 漏洞)

I believe you're fine and patched up to date, just slightly confused on nomenclature. Fantastic job btw on finding and running that query, many folks don't go to that effort.

Despite the similarity in names, SQL Server 2008 (10.00) and SQL Server 2008 R2 (10.50) are distinct versions of the product SQL Server. The Edition, denotes the product license, in your case, Express.

A Service Pack, SP, is a collection of Cumulative Updates, CU, and usually some minor feature fixes/improvements. To further muddy the waters, a Hot Fix or QFE is a software patch that is focused on fixing a specific issue.

The best list for tying versions to available fixes is this site, SQL Server Version Database At this time, you are at the current Service Pack level "2008 + Service Pack 2" as your version number indicates (10.00.4000) There have been 4 Cumulative Updates released since then SP2 and a QFE (which patches an XML vulnerability)

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文