首页 > 解决方案 > Microsoft SQL Server - 附加数据库版本失败问题

问题描述

我有附加数据库的问题。所以,我的团队有一个数据库,我想将数据库安装到我自己的机器上。我要求我的团队分离数据库,以便可以将 .mdf 和日志文件发送给我。当我想附加数据库时,发生了错误

TITLE: Microsoft SQL Server Management Studio
------------------------------

Attach database failed for Server 'MyMachine\SQLEXPRESS'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=14.0.17277.0+((SSMS_Rel_17_4).180625-0100)&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

The database 'Database_Name' cannot be opened because it is version 869. This server supports version 782 and earlier. A downgrade path is not supported.
Could not open new database 'Database_Name'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 948)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=948&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

我试图从https://docs.microsoft.com/en-us/sql/ssms/release-notes-ssms?view=sql-server-ver15下载补丁,这是正确的解决方案吗?我使用 Microsoft SQL Server Management Studio 17 Express Edition

谢谢

标签: sql-server

解决方案


推荐阅读