SQL Server 2000 Live数据镜像 [英] SQL Server 2000 Live data mirroring
问题描述
我目前使用2个sql 2000服务器，一个我可以查询，但不添加任何数据库，导致第二个有很多查询，使用第一个作为链接服务器。我想在仍然查询实时数据的同时提高性能。
I am currently working with 2 sql 2000 servers one I can query but not add any databases to which lead to the second one having lots of queries that use the first as a linked server. I would like to improve performance while still querying live data.
可以将实时数据镜像到第二个服务器，这样查询将是该服务器的本地？我的选择是什么？
Is it possible to mirror the live data to the second server, that way the queries would be local to that server? What are my options?
如果需要从sql 2000升级是可能的。
If an upgrade from sql 2000 is needed that is a possibility.
推荐答案
你有三个选择。
-
使用复制将数据从第一个服务器移动到第二个服务器。这有一个缺点，由于需要为每个更改拆除和设置复制，使更改非常困难。
use replication to move the data from the first server to the second. This has the drawback of making changes extremely difficult due to the need to tear down and set the replication up for each change.
在SQL 2000中使用日志传送。这个想法是，在主服务器上发生更改后，数据将立即传输到备用服务器。我没有这样做，所以我不知道自己的缺点。 http://www.microsoft.com/technet/prodtechnol/ sql / 2000 / maintain / logship1.mspx
Use log shipping in SQL 2000. The idea is that immediately after changes occur on your primary server, data is transferred to your standby server. I haven't done this so I dont personally know the drawbacks. http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/logship1.mspx
升级到SQL 2005或SQL 2008并使用其内置的镜像功能。注意，你应该做一些公平的深度测试，以确保一切正常工作后，在这样的主要升级。虽然兼容，我不得不对升级后的某些应用程序查询进行调整，以保持一切正常运行。
Upgrade to SQL 2005 or SQL 2008 and use the built in mirroring features of it. Be aware that you should do some fairly in depth testing to make sure everything works correctly after a major upgrade like this. Although compatible I have had to make tweaks to certain application queries after an upgrade to keep everything functioning normally.
这篇关于SQL Server 2000 Live数据镜像的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
