从 SQL 2000 - 2008 升级 - 日志传送 [英] Upgrading from SQL 2000 - 2008 - Log Shipping

问题描述

我正在从 SQL 2000 - SQL 2008 升级是否可以(或可行)设置从服务器 A(具有 sql 2000 数据库)到服务器 B(具有 SQL 2008 实例)的日志传送

I'm in the process of upgrading from SQL 2000 - SQL 2008 Would it be possible (or feasable) to set up log shipping from Server A - that has the sql 2000 database on, to Server B - that has the SQL 2008 instance on

或者有更好的升级方式吗?

Or is there a better way of upgrading?

我显然需要使用新的 SQL 2008 实例测试我的应用程序......

I need to obviously test my application using the new SQL 2008 instance....

推荐答案

您当然可以手动配置所需的步骤并编写脚本，因为日志传送只是从主服务器获取的事务日志文件的副本运送到辅助服务器，然后随后恢复.只需确保相应设置 SQL Server 2008 服务器上数据库的数据库兼容级别即可.

You can certainly configure and script the steps that would be required manually, as Log Shipping is simply a copy of your transaction log file taken from the Primary server that is shipped to the Secondary server and then subsequently restored. Just ensure that the database compatibility level of the database on the SQL Server 2008 server is set accordingly.

不过，我怀疑您可能无法使用 SQL Server 2000 中的向导配置日志传送，但我不确定这一点.不过，您当然可以很容易地对此进行测试.

I suspect however that you may not be able to configure Log Shipping using the Wizards within SQL Server 2000 however, I am not certain on this point. You could of course test this quite easily though.

所以要明确一点，您可以从 SQL Server 2000 向上游记录船舶到 SQL Server 2008，但不能从 SQL Server 2008 向下游记录船舶 到 SQL Server 2000

So just to be clear, you can log ship upstream from SQL Server 2000 to SQL Server 2008 but you cannot Log Ship downstream from SQL Server 2008 to SQL Server 2000

如果要将 SQL Server 2000 服务器上的日志传送配置升级到 SQL Server 2008，请参阅以下内容 微软参考

If you want to upgrade the Log Shipping Configuration on a SQL Server 2000 server to SQL Server 2008 then see the following Microsoft Reference

这篇关于从 SQL 2000 - 2008 升级 - 日志传送的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！