This article is a mirror article of machine translation, please click here to jump to the original article.

Architect_Programmer_Code Agriculture Network»Architect › Database & Database › Microsoft SQL Server › Regarding SQL 2000 Database Attachment to SQL 2012 Compatibility Issues...
View: 10781|Reply: 0

[Source] Regarding the compatibility issue of SQL 2000 database attachment to SQL 2012

[Copy link]
Posted on 2/15/2016 3:40:27 PM | | |
TITLE: Microsoft SQL Server Management Studio
------------------------------

Restore of database 'Fisher_NewYearCard' failed. (Microsoft.SqlServer.Management.RelationalEngineTasks)

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

System.Data.SqlClient.SqlError: The database was backed up on a server running version 8.00.2039. That version is incompatible with this server, which is running version 11.00.2100. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.SmoExtended)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=11.0.3000.0+((SQL11_PCU_Main).121019-1322+)&LinkId=20476

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

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



Attach this error:

Baidu translates as follows:

Title: Microsoft SQL Server Management Studio
------------------------------
The fisher_newyearcard to restore the database failed. (Microsoft SQL Server management.) relationalenginetasks）
------------------------------
ADDITIONAL INFORMATION:
system.data.sqlclient.sqlerror: Version 8.00.2039 on the database backup server. This version is not compatible with servers, this is running version 11.00.2100. Either restore the database to a server that supports backups, or use a backup that is compatible with that server. (Microsoft SQL Server.) smoextended）
Help, click: http://go.microsoft.com/fwlink?prodname=Microsoft+SQL+Server and prodver=11.0.3000.0+((sql11_pcu_main). 121019-1322+) and linkid = 20476
------------------------------
Buttons:
All right
------------------------------



We all know that higher versions of software are generally compatible with lower versions of data

But why can't sql?

The reason, very simple, one is too high, the other is too low, SQL Server is Microsoft's

Microsoft feels that SQL 2012 is not compatible with SQL versions that are too low.




Solution:

The library of 2000 can be attached to 2005 or 2008, and then to 2012, yes.




Previous:ASP.NET The role of machineKey and how to use it
Next:js page refresh Summary of the difference between locatio{filter}n.reload and locatio{filter}n.replace

Related Posts
Disclaimer:
All software, programming materials or articles published by Code Farmer Network are only for learning and research purposes; The above content shall not be used for commercial or illegal purposes, otherwise, users shall bear all consequences. The information on this site comes from the Internet, and copyright disputes have nothing to do with this site. You must completely delete the above content from your computer within 24 hours of downloading. If you like the program, please support genuine software, purchase registration, and get better genuine services. If there is any infringement, please contact us by email.
Mail To:help@itsvse.com