尝试将备份还原到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)
有没有办法从较新的(在我的情况下10.50.1600)版本的sql Server Express中获得与旧版本(在我的情况下为10.00.2531)版本兼容的备份?
解决方法
您已经使用SSMS中的导入/导出向导来迁移所有内容
使用备份/恢复或分离/附加没有“降级”