An error occurred when attaching the database(s). Click the hyperlink in the...

小渣渣

An error occurred when attaching the database(s).  Click the hyperlink in the Message column for details.

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

Attach database failed for Server 'xxxx'.  (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?P ... rodVer=11.0.3000.0+((SQL11_PCU_Main).121019-1322+)&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 'XMPP' 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 'XMPP'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 950)

For help, click: http://go.microsoft.com/fwlink?P ... ID=950&LinkId=20476

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

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

从网上下载了一个数据库，然后，我想附加到2012的sql上，然后报错

估计是，数据库的版本太低了，然后2012不支持了。

解决办法如下：

1.创建一个MSSQL 2008数据库，将MSSQL 2000数据库附加到 MSSQL 2008后，再进行备份

2.创建一个MSSQL 2012数据库，再将MSSQL 2008数据库的备份附加到MSSQL 2012