如何恢复数据库..？ [英] how to restore database..?

问题描述

下面这个错误是什么意思..



数据库是在运行版本10.50.4033的服务器上备份的。该版本与此服务器不兼容，该服务器运行的是10.00.2531版本。在支持备份的服务器上还原数据库，或使用与此服务器兼容的备份。

解决方案

您的备份来自较新的服务器版本而您正在尝试恢复到旧版本。



首先尝试升级目标服务器。

您的源服务器版本为2008 R2 SP2。

目标服务器的版本为2008 SP1。

（来源： Microsoft SQL Server版本清单 [ ^ ]）



我会尝试将目标服务器升级到 SQL Server 2008 Service Pack 4 尝试恢复备份之前[ ^ ]。

What does it mean of this below error..

The database was backed up on a server running version 10.50.4033. 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.

解决方案

Your backup is from a newer server version and you are trying to restore to an older version.

Try upgrading your destination server first.

Your source server has version 2008 R2 SP2.
Your target server has version 2008 SP1.
(Source: Microsoft SQL Server Version List[^])

I would try to upgrade the target server to SQL Server 2008 Service Pack 4[^] before attempting to restore the backup.

这篇关于如何恢复数据库..？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！