由于服务器编号差异，无法在sql 2008 R2中复制数据库 [英] unable to copy a database in sql 2008 R2 due to server number difference

问题描述

我正在pendrive中从笔记本电脑复制sql2008r2数据库。在桌面上我安装了相同的sql2008r2。在桌面我正在创建一个数据库。现在在桌面中我使用恢复数据库并选择从设备来恢复备份集。它不起作用，并说'Compatability error- source来自10.50.1600，目标服务器是10.0.1600'。当我在两台机器上使用相同的sql2008r2安装时，为什么会这样呢？早期的桌面是SQL2008。有谁可以指导？

问候。

I am copying a sql2008r2 database from a laptop in a pendrive. In a desktop I have installed the same sql2008r2. In the desktop I am creating a database. Now in the desktop I use 'restore database' and select 'from device' to restore backup sets. It doesnt work and says' Compatability error- source is from 10.50.1600 and destination server is 10.0.1600'. Why this is so when I have used the same installation of sql2008r2 in both the machines? Earlier the desktop was with SQL2008. Can anyone guide?
Regards.

推荐答案

请仔细阅读邮件。笔记本电脑和台式电脑上的MS SQL服务器版本不一样。

请参阅： http://www.sqlteam.com/article/sql-server-versions [ ^ ]

在桌面计算机上更新SQL服务器，然后重试。

Please, carefuly read the message. Versions of MS SQL server on laptop and desktop computer are not the same.
Please, see this: http://www.sqlteam.com/article/sql-server-versions[^]
Update your SQL server on desktop computer and try again.

这篇关于由于服务器编号差异，无法在sql 2008 R2中复制数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！