从 SQL 2000 升级 - 2008 - 日志传送
我正在从 SQL 2000 升级到 SQL 2008 是否可以（或可行）设置从服务器 A（运行 sql 2000 数据库）到服务器 B（运行 SQL 2008 实例）的日志传送
或者是否有更好的升级方法？
我显然需要使用新的 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?
I need to obviously test my application using the new SQL 2008 instance....
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您当然可以手动配置和编写所需步骤的脚本，因为日志传送只是从主服务器获取的事务日志文件的副本，该副本被传送到辅助服务器，然后随后恢复。只需确保相应设置 SQL Server 2008 服务器上数据库的数据库兼容级别即可。
不过，我怀疑您可能无法使用 SQL Server 2000 中的向导来配置日志传送，但我对此并不确定。当然，您可以很容易地对此进行测试。
因此，需要明确的是，您可以将日志从 SQL Server 2000 向上游发送到 SQL Server 2008，但不能将日志从 SQL Server 2008 向下游发送到 SQL Server 2000
如果要将 SQL Server 2000 服务器上的日志传送配置升级到 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.
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.
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
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