尝试附加数据库失败，因为它是 782 版 [英] Trying to attach a database fails because it is version 782

问题描述

我最近重新安装了 Windows，并尝试使用现有数据库再次设置 SQL Server.我已经尝试安装 SQL Server 2012 和 2014，并不断收到相同的错误.报错说数据库是782版本，这个版本的SQL Server只兼容706及以下版本.我在 SQL Server 2012 和 2014 上都遇到了这个错误.我认为 2014 与 782+ 兼容.. 谁能为我提供一些关于如何附加一个该死的数据库的指导?沮丧...

I recently reinstalled Windows and am trying to set up SQL Server again with an existing database. I've tried installing SQL Server 2012 and 2014, and continuously get the same error. The error says that the database is version 782 and this version of SQL Server is only compatible with 706 and below. I get this error with both SQL Server 2012 and 2014. I thought 2014 was compatible with 782+.. Can anyone provide me with some guidance as to how to attach a damn database? Frustrated...

图片来自 SQL Server 2014..

Image from SQL Server 2014..

请注意，我在 2012 年遇到了同样的错误.在重新安装操作系统之前一切正常.

and just to note, I get the same error in 2012. Everything was functioning before the OS reinstall.

推荐答案

数据库必须设置为旧版本或相同版本的服务器.您不能将 2012 服务器与 2014 数据库一起使用.

Database must be set to older or same version of the server. You cannot use 2012 server with 2014 database.

根据此链接:http://sqlserverbuilds.blogspot.com/2014/01/sql-server-internal-database-versions.html 782 是 2014 版本，您不能使用早期版本.

According to this link: http://sqlserverbuilds.blogspot.com/2014/01/sql-server-internal-database-versions.html 782 is version 2014 and you cannot use earlier versions.

如果您尝试过 SQL Server 2014，请更新到最新版本.

If you tried SQL Server 2014, update to latest version.

还要确保您安装的服务器不仅仅是管理工具，因为您说图像是 2014 年的，但服务器支持 706，这意味着它是 2012 年.

Also make sure you install server not just management tools, since you say that the image is from 2014 but server supports 706, which means it's 2012.

您可以从您的管理工作室执行SELECT @@version"以查看您正在运行的服务器版本.

You can do 'SELECT @@version' from your management studio to see on which version of server you're running.

这篇关于尝试附加数据库失败，因为它是 782 版的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！