SQL Server数据库备份错误 [英] SQL Server Database backup error

问题描述

我有另一台PC的备份文件，我无法更改此文件

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

i have backup file from another pc i cannot change this file

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

推荐答案

您无法从较旧服务器上的较新服务器还原备份.

将目标SQL Server升级到较新版本(安装Service Pack)，然后还原备份.

You cannot restore backups from newer servers on older servers.

Upgrade your destination SQL server to the newer version (install service packs) and then restore your backup.

这篇关于SQL Server数据库备份错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！