一尘不染

将备份恢复到旧版本的 SQL Server

sql-server

尝试将备份还原到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)兼容的备份?


阅读 98

收藏
2022-11-08

共1个答案

一尘不染

您必须使用 SSMS 中的导入/导出向导来迁移所有内容
使用备份/恢复或分离/附加不可能“降级”

2022-11-08