错误附加数据库文件 - sql server 2016 [英] Error Attaching database file - sql server 2016
问题描述
TITLE:Microsoft SQL Server Management Studio
------------------------------
服务器'HOME03'附加数据库失败。 (Microsoft.SqlServer.Smo)
如需帮助,请单击:http://go.microsoft.com/fwlink?ProdName = Microsoft + SQL + Server& ProdVer = 14.0.17289.0 +((SSMS_Rel_17_4).181117-0805)& EvtSrc = Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText& EvtID = Attach + database + Server& LinkId = 20476
------------------------------
附加信息:
执行Transact-SQL语句或批处理时发生异常。 (Microsoft.SqlServer.ConnectionInfo)
--------------------------- ---
无法升级数据库'AmnDb001',因为此版本的SQL Server不支持其非发行版本(539)。您无法打开与此版本的sqlservr.exe不兼容的数据库。您必须重新创建数据库。
无法打开新数据库'AmnDb001'。 CREATE DATABASE被中止。 (Microsoft SQL Server,错误:950)
如需帮助,请单击:http://go.microsoft.com/fwlink?ProdName = Microsoft %% 20SQL%20Server& EvtSrc = MSSQLServer& EvtID = 950& LinkId = 20476
----------------------- -------
按钮:
OK
-------- ----------------------
版本539显示您正在使用SQL Server 2000,并且SQL Server 2012 +不支持它。
请参阅: < a href ="https://msdn.microsoft.com/en-us/library/ms143729(v=sql.105).aspx"rel ="nofollow"style ="margin:0px; pa dding:0px; border:0px;字体风格:继承;字体变:继承;字体重量:继承;行高:继承; FONT-FAMILY:继承;垂直对齐:基线;颜色:#005999">已弃用
SQL Server中的数据库引擎功能
您可以将SQL Server 2000附加到SQL Server 2005或2008,然后备份和/或附加SQL Server 2012+版本
TITLE: Microsoft SQL Server Management Studio
------------------------------
Attach database failed for Server 'HOME03'. (Microsoft.SqlServer.Smo)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=14.0.17289.0+((SSMS_Rel_17_4).181117-0805)&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)
------------------------------
Database 'AmnDb001' cannot be upgraded because its non-release version (539) is not supported by this version of SQL Server. You cannot open a database that is incompatible with this version of sqlservr.exe. You must re-create the database.
Could not open new database 'AmnDb001'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 950)
For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft%20SQL%20Server&EvtSrc=MSSQLServer&EvtID=950&LinkId=20476
------------------------------
BUTTONS:
OK
------------------------------
The version 539 shows that you are using the SQL Server 2000 and it is not supported in SQL Server 2012+.
Please refer: Deprecated Database Engine Features in SQL Server
You can attach SQL Server 2000 to SQL Server 2005 or 2008 and then take a backup and /or attach SQL Server 2012+ versions
这篇关于错误附加数据库文件 - sql server 2016的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!