尝试将备份还原到SQL Server Express 2008数据库时,出现以下错误:
Restore failed for Server '...\SQLEXPRESS'. (Microsoft.SqlServer.SmoExtended) System.Data.SqlClient.SqlError: The database was backed up on a server running version 10.50.1600. That version is incompatible with this server, which is running version 10.00.2531. Either restore the database on a server that supports the backup, or use a backup that is compatible with this server. (Microsoft.SqlServer.Smo)
有没有办法从 SQL Server Express 的较新(在我的情况下为 10.50.1600)版本中获取与旧版本(在我的情况下为 10.00.2531)兼容的备份?
您必须使用 SSMS 中的导入/导出向导来迁移所有内容 使用备份/恢复或分离/附加不可能“降级”