如何将旧备份从SQL Server 7 SP4还原到最新的SQL Server版本? [英] How to Restore a old Backup from SQL Server 7 SP4 to newest SQL Server versions?
问题描述
我正在尝试还原我的一个非常旧的代码,那时候数据库是ms访问权限,然后我升级到SQL Server 7 SP4,现在我想还原那些旧备份,但是SQL Server 2014不允许这样。
I'm trying to restore an very old code of mine, in that time the database was ms access and then I upgraded to SQL Server 7 SP4, now I want to restore those old backup, but SQL Server 2014 does not allow this..
所以我想知道如何在不安装SQL Server 7的情况下还原那些备份。.
So I would like to know how can I get to restore those backup, without installing SQL Server 7 ..
Thx U
推荐答案
这是三版规则。例如,对于SQL Server 2012,只能还原2008R2、2008和2005版本的数据库。同样,SQL Server 7数据库可以还原到2005,但没有更高版本。要将其还原到2014年,必须(按规则)必须将其还原到2005年,在2005年进行备份并将其还原到2012年,然后才将2012年备份还原到2014年。但是,有一个例外:2014年承认2005 SP4,因此您可以跳过第二步,直接从2005年恢复到2014年(但仅从2005 SP4开始)。
It's a 'three-version' rule. For example, to SQL Server 2012 one can only restore databases from 2008R2, 2008 and 2005 versions. Similarly, SQL Server 7 database can be restored to 2005, but no later version. To restore it to 2014, you will (by the rule) have to restore it to 2005, take a backup on 2005 and restore it to 2012, and only then 2012 backup restore to 2014. However, there is an exception: 2014 acknowledges the 2005 SP4, so you can skip the second step, and restore straight from 2005 to 2014 (but only from 2005 SP4).
这篇关于如何将旧备份从SQL Server 7 SP4还原到最新的SQL Server版本?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!